Timing Issue for Moving Row from Staging Sheet to Main Sheet
I'm building a workflow for our HR and Recruiting department to use to track job posting requisitions. If they check a box on the master sheet to repost the job again I am copying the row to a staging sheet, making a few cell updates to change values or clear values, then want to move it back to the master sheet as a new job requisition.
I'm running into a timing issue though. When the row is moved to staging I have workflow automations built to clear a handful of columns, set a few date fields automatically and change a few cell values. I need to trigger the row moving back to the master record after all of those actions are finished but in my testing I can't get it to move at the right time, it seems to be moving back before all of the actions are complete.
It doesn't seem like I can set the order of the workflows to happen either, or drag and drop. Has anyone found a way to get around a timing issue like this? Or, if I create the automations in the right order, with moving to the sheet as the bottom one in the list, will that resolve it? I wasn't sure if workflow automations process from top to bottom or not.
Help Article Resources
Check out the Formula Handbook template!