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
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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å
-
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:andree@workbold.com | 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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 439 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 67 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!