How to prevent a moving automation to take place before copying.
I've created a workorder file in Smartsheet. I've created a central inputfile and the incoming orders are moved to different sheets acording certain parameters. However, sometimes (when a certain box is checked) it is necessary that a row first is being copied to a certain sheet and afterwards being moved to another. So on the same line I do than have a copy and a move automation. In general this works quite smoothly, however I experience that when many workorders come in in a short time, it looks like the moving automation takes place before copying, so we're missing certain workorders.
I tried to prevent this by set the moving to 'hourly' iso 'when triggered'. However, smartsheet says that the automation cannot be set to hourly.
Another idea I had was changing all the moving to 'copy' and make an automation to delete the rows after one or two days, but that automation doesn't exist.
Can anybody help me how I can secure the copying takes place before moving the row.