the same source and destination name
Hello together,
I'm trying to copy the entire row to another sheet when the status changes, and I'm getting an error message saying that the row cannot be added because the name of the source and destination is the same. When I created a test sheet with the same column names, it worked. How do I find the error?
Thanks for your response.
Best Answer
-
Make sure that if you have a system generated column such as the auto-number, one of the Created, or one of the Modified type columns, that the column in the destination sheet with that same name is also the same column type.
Answers
-
Can you provide a screenshot of the error message?
-
-
Hi @Joel Nigg
I hope you're well and safe!
Have a look at this.
System columns must be of the same type
If a system column in one sheet has the same name as a non-system column in the other sheet, the workflow is disabled and you’ll receive the following message:
Brandfolder Image
If your workflow becomes disabled with the above message, you have to rename the affected system column.
If there are system columns in both the source and destination sheet, the names don't have to match. The values are moved to the destination sheet based on column type rather than column name.
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.
-
Make sure that if you have a system generated column such as the auto-number, one of the Created, or one of the Modified type columns, that the column in the destination sheet with that same name is also the same column type.
-
Thank you very much! One column was a "Text/Number" and the other was a "Created date". After the change everything worked fine.
-
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.
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives