How to Automatically Update Trigger Column in Google Sheets

[Joker199]

How to set a job to set every 5 sec autoatically update trigger column in google sheets?

 

[Pabblymember11]

Hey @Joker199

The data need to be passed to your trigger column manually or if the data is coming from a third-party application why has to be come through the trigger column?

 

[Joker199]

Hey @Joker199

The data need to be passed to your trigger column manually or if the data is coming from a third-party application why has to be come through the trigger column?

Hey Supreme,
Because some column I need to use ARRAYFORMULA, and ARRAYFORMULA doesn't work in trigger auto.

 

[Pabblymember11]

If you are using a formula in the triggering column then we would recommend you not use any formula, as it might interfere with the app script which sends the data to the workflow.