I want to take multiple actions when status of a task goes to Complete.
- I want to capture the status date
- I want to Lock the row from further updates
- I want to copy the row to another sheet (capture all tasks that completed)
I created 2 separate workflows to do these actions, and they appear to be working. #2&3 are combined into one workflow, and #1 is by itself. But it also appears that the sequence of the workflows is important. For example, if I lock and copy the row before I capture the status date, the new copied row does NOT have the status date in it. Can all 3 of the above actions be performed on one single workflow? If I use multiple workflows, does the sequence matter?