Copy Rows to Another Sheet not working - Column has the same name as a system column on the source

Help please.

I am trying to set up an automation that copies data from my Main Purchase Request Sheet to my Line Items Sheet. However, I keep encountering an error message stating, "Rows can't be added to the destination worksheet because a column has the same name as a system column on the source sheet."

Here are the specifics of my sheets:

Main Purchase Request Sheet Columns:

PR#
Status
Requestor Name
Request Category
Other Request
Request Reason
Department
Delivery Date
Delivery Address

Line Items Sheet Columns:

PR#
Item #
PR Line Item ID
Item Name
QTy
Uom
Price
Total Price
Supplier Details
Status

Find more posts tagged with

Automations

Workflows in Smartsheet

Accepted answers

All comments

kowal

Hey Sandra,

could you tell me what is the name of the system column in the source and destination sheet? The system column is the one with bold name where the hierarchy is kept.

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.