How do I get two automations and a cell formula to execute in the right sequence?

Todd Tompkins

I have a sheet the automatically coordinates documents. There are three things I am trying to get to execute in the right order. I understand the principle of workflow execution (the most recent modified workflow runs last). The variable I am adding is that between the two workflows is a formula in a cell that populates based on the cell that populates a date from the first workflow. Here is the concept:

1. Sent to Date (Workflow) - When a review concurs with a document, this automation records the date in the appropriate cell.
2. Due Date - Cell uses a formula to calculate the due date form the date generated from the above workflow.
3. Branch Coordination - This workflow runs after the first workflow and sends an update request action email (with due date) to the next reviewer.

Thoughts?

Todd Tompkins

Thank you Courtney. I came to the same conclusion after posting this. I am in the process of testing. I initiated a test and am waiting 24 hours before I continue the coordination to see how if the solution works.

Courtney S.

To make sure the second automation runs as the third step, use step two, the changing of the Due Date field, as the trigger for the second automation.

Todd Tompkins

Thank you Courtney. I came to the same conclusion after posting this. I am in the process of testing. I initiated a test and am waiting 24 hours before I continue the coordination to see how if the solution works.