the same source and destination name

Joel Nigg · 01/30/24

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.

Paul Newcome · 01/31/24

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.

Paul Newcome · 01/30/24

Can you provide a screenshot of the error message?

Joel Nigg · 01/31/24

@Paul Newcome sure.

Andrée Starå · 01/31/24

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!

Paul Newcome · 01/31/24

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.

Joel Nigg · 02/01/24

@Andrée Starå @Paul Newcome

Thank you very much! One column was a "Text/Number" and the other was a "Created date". After the change everything worked fine.

Andrée Starå · 02/01/24

@Joel Nigg

Happy to help!

Glad you got it working!

Paul Newcome · 02/02/24

Happy to help. 👍️

Smartsheet Basics

Smartsheet Basics

the same source and destination name

Best Answer

Answers

System columns must be of the same type

Quick Links

Categories

Trending in Smartsheet Basics

Create New Folders in Sheets Directory

Automations Are Not Triggering

How to make hyperlinks clickable in reports?