Update Rows without Duplicating Row when copied from another Sheet
We are trying to figure out a solution for rows that are copied to another sheet. We are using the automated workflow to add the row to another sheet when it meets certain criteria. That is working properly however, when an update is made to that row on the original sheet it is duplicating the row on the other sheet. Is there a way to update a field on the original row and just have that specific update copied to the original corresponding row that was created (not create a new row)? Would a vlookup work for this scenario?
Answers
-
Do you have access to Data Shuttle? If so, that would be the best place to start to update the rows without duplicating them.
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 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
- 305 Events
- 34 Webinars
- 7.3K Forum Archives