Auto Created a row but the formula value is not being added to the row

[arpitbadshah01]

I am creating a workflow where data is being fetched from site and pasted in google sheet by CREATING A NEW ROW. New row have some columns which i use for formula calculation. for example - data is fetched for A to D column and than in E column there it is formula to calculate,
so whenever, a new row is created, Formula in E column is not applied automatically by pabbly. what to be done. and how it can be automate.?

 

[nitingoyal]

Add one more step
Number formatter >> Spreadsheet formulas
Then pass the value to column E

 

[Arshita]

Hey @arpitbadshah01

We advise our users not to use any formulas or filters in their Google Sheets that might interfere with the incoming data with Google's script and trigger the workflow.

If you want to trigger column E, you must enter the correct column in the trigger column. It should be the last filled column of the sheet.