Can you automate 2 requests for update in same row?
I am trying a workaround to ensure stakeholders are completing all the fields in a request for update automation.
We have two party's that need to fill out the same row.
I created a form with required fields for the first party.
Then I created a workflow so that when a trigger is met from the form, a request for update is sent to the 2nd party. But we want that 2nd party to fill out all the fields. Since a request for update does not include this feature, I tried a workaround.
I created 2 separate work flows with the same one trigger:
One is when rows are added/changed, another when rows are changed.
The first workflow sends a request for update when the trigger is met.
The second workflow has a condition that when certain fields are blank, another request for update is sent.
However, this does not work. The only way I can automate a follow up reminder is through an alert someone (the enterer) which takes them to the entire sheet.
How do I ask for a 2nd request an update (and 3rd or 4th until complete) for blank fields in a row?
Help Article Resources
Check out the Formula Handbook template!