Systems columns

Hi, I have a form that gathers data. The team works on it and rows change status. Once a row changes to approved, I'd like to move it off to another sheet but my automation is giving me an error - sheet you are moving data too has a systems column of the same name as your original sheet. I have deleted my created by/date, modified by/date columns which I understood to be the system columns. Is there something else I'm missing?

Best Answer

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓

    Hi,

    I hope you're well and safe!

    Have you checked these?

    When you move rows or copy rows with system or baseline columns

    • If a column exists on the destination sheet but not on the source sheet, the Created By column will note the date/time when the row was moved or copied.
    • The Created By column will show the user who moved or copied the row. If the row was moved or copied by automation, it will display [email protected].
    • If a column exists on both the destination and the source sheet, the value from the source sheet will carry over to the destination sheet. Unlike other column types, the column names do not need to match.

    If a system column or a baseline column has a name that matches a column with a different column type (dropdown, text/number, etc.), you may encounter the following errors:

    • Rows can't be added to the destination sheet because a column has the same name as a system column on the source sheet.
    • Rows can't be added to the destination sheet because a system column has the same name as a column on the source sheet.

    To resolve this, you can either rename one of the columns or change the column type so it matches the source sheet.

    Did that work/help?

    I hope that helps!

    Be safe, and have a fantastic week!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓

    Hi,

    I hope you're well and safe!

    Have you checked these?

    When you move rows or copy rows with system or baseline columns

    • If a column exists on the destination sheet but not on the source sheet, the Created By column will note the date/time when the row was moved or copied.
    • The Created By column will show the user who moved or copied the row. If the row was moved or copied by automation, it will display [email protected].
    • If a column exists on both the destination and the source sheet, the value from the source sheet will carry over to the destination sheet. Unlike other column types, the column names do not need to match.

    If a system column or a baseline column has a name that matches a column with a different column type (dropdown, text/number, etc.), you may encounter the following errors:

    • Rows can't be added to the destination sheet because a column has the same name as a system column on the source sheet.
    • Rows can't be added to the destination sheet because a system column has the same name as a column on the source sheet.

    To resolve this, you can either rename one of the columns or change the column type so it matches the source sheet.

    Did that work/help?

    I hope that helps!

    Be safe, and have a fantastic week!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Melitta
    Melitta ✭✭✭✭✭

    This is what I was missing -

    • If a column exists on both the destination and the source sheet, the value from the source sheet will carry over to the destination sheet. Unlike other column types, the column names do not need to match.


    Thank you @Andrée Starå

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Excellent!

    Happy to help!

    Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!