Moving large amounts of rows

SteyJ
SteyJ ✭✭✭✭✭✭
edited 01/04/24 in Formulas and Functions

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?

Sincerely,

Jacob Stey

Tags:

Best Answer

  • Mr. Chris
    Mr. Chris ✭✭✭✭✭
    Answer ✓

    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.

Answers

  • Mr. Chris
    Mr. Chris ✭✭✭✭✭
    Answer ✓

    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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!