Workflow Automation changing cell contents
I have 2 'check' columns that indicate Start Confirmed and End Confirmed.
I have 2 Workflow automations;
- When 'Start Actual Confirmed' is checked then 'Status' changes to 'In Progress'.
- When 'End Actual Confirmed' is checked then 'Status' changes to 'Complete'
The issue I am running into is that when a user checks 'Start Actual Confirmed' AND 'End Actual Confirmed' and THEN saves the worksheet the only automation that triggers is the 'Start . . .' so the 'Status' is changed to 'In Progress'. The 'check' in 'End Actual Confirmed' does not trigger corresponding workflow automation.
Suggestions? Is there a workaround? Or do I need to instruct team to check 'Start . . . ' save and THEN check 'End . . . ' and save?