Modified Columns triggers change in another Column
I want to trigger a change to a checkbox (say Change Indicator) whenever a row is added or modified. The Change Indicator would then be used to trigger a workflow. I need this because a system generated column cant be used to trigger a workflow so I'm creating an alternate mechanism to do this. Effectively this looks like: data is entered through a form which triggers an approval workflow, if the entry is declined it alerts someone to change the entry, changes cause the modified column to update which causes the Change Indicator checkbox to toggle, change to CHange Indicator triggers the approval workflow. Help is appreciated.
Answers
-
To accomplish this you would need to use a third party tool such as Zapier or it can be done with a Copy Row workflow sending a copy to another sheet and cross sheet references.
Help Article Resources
Categories
Check out the Formula Handbook template!