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
Answers
-
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.
The Real Smartsheet Enthusiast
Is there anything else we can help you with? - book your time!
MASA Consult - Your Aligned Smartsheet Partner
Find us on LinkedIn!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!