Systems columns

Melitta

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?

Andrée Starå

https://community.smartsheet.com/discussion/108999/systems-columns

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 automation@smartsheet.com.
• 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!

Andrée Starå

https://community.smartsheet.com/discussion/108999/systems-columns

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 automation@smartsheet.com.
• 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!

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å

https://community.smartsheet.com/discussion/comment/391168#Comment_391168

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!