Move Row Automation lagging terribly
I'm leapfrogging rows from a form collection sheet to an intermediate sheet, and that move row automation works fine. From the intermediate sheet, I'm moving rows to the main data sheet. This is where things are lagging, like stopping for multiple hours for no reason. The rows that are moving have only 5 columns. There's plenty of room in the main sheet. There are only 3 formula fields, and they're not too complex.
The automation trigger is when rows are added, when any field changes, run when triggered, move the row. It hung for about 2 hours. I moved some rows manually, and then all of a sudden it moved the rest itself. Now it's been sitting 45 minutes, over 100 rows have built up, because it's not moving any right now.
Any ideas on how to keep things moving?
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!