Moving large amounts of rows

SteyJ

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?

=Chris Palmer

Hello @SteyJ,

One idea in saving a new workbook is to create a new standard "Text" column next to the "Created Date" column in the new workbook.

In this new column write an INDEX MATCH. Indexing the "Created Date" column from the original workbook to pull in the original "Created Date" results.

Once the formula is filled down you can paste values to hardcode the formula into date values.

To the best of my knowledge I don't think you can modify the actual "Created Date" properties in a new workbook as these are workbook specific. The Index Match in a new column may suffice and offer an alternative solution.

=Chris Palmer

Hello @SteyJ,

One idea in saving a new workbook is to create a new standard "Text" column next to the "Created Date" column in the new workbook.

In this new column write an INDEX MATCH. Indexing the "Created Date" column from the original workbook to pull in the original "Created Date" results.

Once the formula is filled down you can paste values to hardcode the formula into date values.

To the best of my knowledge I don't think you can modify the actual "Created Date" properties in a new workbook as these are workbook specific. The Index Match in a new column may suffice and offer an alternative solution.

CS_

You can try adding in a condition into your automation to limit the numbers of rows it catches down to 3000 - 5000 rows at a time. I've noticed over 5000 rows and an automation fails. You'll also need to kick it off with a row change, not running it manually.