Copying Rows to New Sheet

Options

Hello,

I am trying to enable a workflow automation when an item's status changes to "Approved", the row is automatically copied to another grid.


I keep receiving the "Rows can't be added to the destination sheet because a column has the same name as a system column on the source sheet" alert. The issue is, this is not true. The system columns are unique on both sheets.


Any insight?


Answers

  • Frank S.
    Frank S. ✭✭✭✭✭✭
    Options

    Greetings @ClaireWallace,

    My suggestion would be to create a new sheet to copy to and do not add any columns, leaving the default columns.

    When the criteria are met, the copy will occur, migrating all of the rows from the original sheet to the sheet where the copy occurred. This method will ensure that there are no naming convention issues or glitches.

    I hope this helps resolve your problem.

    Frank Smith, PMP

    Assistant Director | IT Special Projects Mgr.

    Oregon Parks & Recreation Department

    If my response helps, please mark it as an accepted answer. 😎

  • Alesha Frerichs
    edited 08/10/23
    Options

    Hi @ClaireWallace, I was having the same issue & found this about system columns. I had a column set as an auto number format on one sheet & a regular column on the other w/same column title. I updated both sheets to be the same & it fixed the issue.


  • ClaireWallace
    ClaireWallace ✭✭✭✭
    Options

    Awesome. Thank you for your assistance, Alesha Frerichs!