Unable to see auto-collection of response from Google sheets

[Pratyush]

Your Task History ID

1

I've created a form which seeks certain numbers as inputs. All the inputs are automatically recorded in a linked Google sheet. Based on those inputs, I want to calculate certain values which I need to ultimately see in a same/separate worksheet in Google sheets. Hence. I'm using query function to copy all the values received from the form and formulae in the following columns to calculate the dependent variables I wish to. Eventually, I want to see all the independent/dependent variables in Google Slides. However, I'm unable to see any automated response collection in Pabbly for dependent variables since they are neither collected from the form nor manually input. How can I resolve this issue?

 

[ArshilAhmad]

Hi @Pratyush,

For Google Sheets, we do not support formula-based triggers. The data must either be entered manually into the trigger column or through an API.

If any formula is added to the trigger column of the Google Sheet, then automation will not work.