Copying Rows to New Sheet

Hello,

I am trying to enable a workflow automation when an item's status changes to "Approved", the row is automatically copied to another grid.

I keep receiving the "Rows can't be added to the destination sheet because a column has the same name as a system column on the source sheet" alert. The issue is, this is not true. The system columns are unique on both sheets.

Any insight?

Screenshot 2023-08-01 at 10.01.30 AM.png

Find more posts tagged with

Workflows in Smartsheet

Accepted answers

All comments

Frank S.

Greetings @ClaireWallace,

My suggestion would be to create a new sheet to copy to and do not add any columns, leaving the default columns.

When the criteria are met, the copy will occur, migrating all of the rows from the original sheet to the sheet where the copy occurred. This method will ensure that there are no naming convention issues or glitches.

I hope this helps resolve your problem.

Alesha Frerichs

Hi @ClaireWallace, I was having the same issue & found this about system columns. I had a column set as an auto number format on one sheet & a regular column on the other w/same column title. I updated both sheets to be the same & it fixed the issue.

ClaireWallace

Awesome. Thank you for your assistance, Alesha Frerichs!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.