Duplicating multiple entries of the same Row based on a cell value
Is there a way to automatically duplicate a row once it is added from a form submission based on a cell value in that row?
Answers
-
The most immediate solution that comes to mind is creating an automation rule to copy the row to another sheet, and then an automation rule on the second sheet that moves the copied row back to the first sheet.
Caveat: If you have formulas in your fields in the first sheet, they won't transfer to the second sheet, only the cell values transfer; so when the copied row moves back to the first sheet, it won't have any formulas.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Kelly,
I am faced with the same challenge for my needs. If a specific column is "yes" than the row data (until the Yes) needs top be copied into the next row. I have found information regarding copying into a different sheet, but like you, my needs require copying or moving only to another sheet. I even looked at building my automation from scratch and that was not an option.
Sherry Fox
Data Science & Reporting Specialist | PA Performance & Data Insights
UnitedHealth Group | OptumRx
EAP | Mobilizer | Automagician | Superstar | Community Champion
https://www.linkedin.com/in/sherryfox/
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives