Unable to set-up Copy Rows Workflow, because of system generate columns
Hi,
I wanted to create a workflow, that copies a data to other sheet (destination sheet) whenever a new row is added in source sheet. However, I do have some system generated columns like Added By, Date added, Updated By, Updated Date. The destination sheet was also formatted and designed as a same way as source sheet. I have even tried renaming the system generated columns differently in destination sheet. Can someone please help me with this?
Thanks,
Mounika
Best Answer
-
Hi @Mounika,
I had a similar problem, to get around it, I created a blank sheet and created the automation to copy the rows across to it. Once copied I then amended the rows in the destination sheet as required.
Hope this helps.
John
Answers
-
Hi @Mounika,
I had a similar problem, to get around it, I created a blank sheet and created the automation to copy the rows across to it. Once copied I then amended the rows in the destination sheet as required.
Hope this helps.
John
-
@John_Foster
Thank you so much! That helped :).
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 303 Events
- 34 Webinars
- 7.3K Forum Archives