Do automated workflows operate on specific rows?
I want to set up an automated workflow that triggers when a column is changed to meet a specific criteria. When this trigger is met, will it run the workflow on every row in the table, or only the specific row which the trigger was met?
My sheet has hundreds of rows and will likely have rows that change and meet criteria daily. I only want the automated workflow to trigger from a specific row and contact the email in that specific row one time when the trigger is met, and I would not like it to run even if that specific row has not changed, but another row in the sheet has.
I have tried to test the workflow by clicking "run now", but it runs for every row despite not meeting criteria.
I hope that makes sense, but please let me know if there are any questions.
Thanks in advance,