Moving large amounts of rows
I'm trying to move 10s of thousands of rows. Automation does not work, it usually fails after trying for a few minutes.
Is it possible to save sheet as new but retain the "created date" data? I need to move the rows one way or another without changing any of the fields (modified column doesn't matter in this scenario)
I've tried automation, highlighting cells and "move to another sheet", it usually fails with this error:
formName: ajax formAction: fa_moveRow serverStatus: false serverStatusText: CriticalException errorCode: 18
Save as new would work if I could keep the created date
Another option would be using the API, but I think the API would just get the same error I'm getting from the core app?
Help Article Resources
Check out the Formula Handbook template!