Executing multiple conditioned automations with one trigger.

Phil Yorkville

Hey Folks,

Basically, I am looking to use an automation (or other tool) to check and fill multiple cells based off of a single checkbox. Specifically:

When ticked, check Col 1, if Col 1 is empty, write HELLO. Then check Col 2, if Col 2 is empty, write HELLO. Then check Col 3, if Col 3 is empty, write HELLO. And so on.

The application is that we have a sheet where data is collected through a form and I would like to be able to fill in all of the gaps with a "No response received" text.

Thanks

Josh W

It seems you can do this with one giant cascade of parallel and series of conditions and actions… but that could get crazy. How many fields might be blank?
First, trigger on row added.
Then, set a condition for if the first cell is blank. If so, go to the action and change the cell. If not, go to the next condition and check if the 2nd cell is blank, and so on.
Then under the first action, set conditions for if the 2nd cell is blank, if not go to the 3rd cell and so on.
Etc. etc. etc, until you finally work down and across the entire set of cells in a path of conditions and actions that look at all possible combinations.
Might just be better to have a bunch of separate automations that all trigger on the same check box or on the row being created.
It would be fun to build & test, but I'll leave that to you :-) Or someone with a better approach!