the same source and destination name

Joel Nigg

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

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

Can you provide a screenshot of the error message?

Joel Nigg

@Paul Newcome sure.

Andrée Starå

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

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

@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å

@Joel Nigg

Happy to help!

Glad you got it working!

Paul Newcome

Happy to help. 👍️