Copy row automation/keeping rows linked
tchav
✭✭✭✭
Is there a way to keep rows linked from the parent sheet to destination sheet? So if we make changes to the row after the copying takes place to make sure that the destination sheet is also updated with any updates that happen in the row from the parent sheet?
Tags:
Answers
-
you can do this with a datamesh.
If you dont own datamesh, you can do index(match()) column formulas on everything except the unique identifier. That way new items are copied over and the data updates as the master source is updated. dont use Vlookup!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 377 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives