Copy row & cell link
Is it possible to link cell changes, attachment updates, and comment updates when a row is automatically copied to another sheet?
The idea is that once the row is copied to another sheet, any changes that are made to the initial sheet (date changes, new attachments and comments) are replicated in the new sheet.
This would be a one-way street. But the biggest issue is that as of now, when the automation runs, the row is copied when a check box is checked and whatever exists in that row is copied over. But when changes are made to the initial sheet, it does not carry over or replicate into the new sheet.
Answers
-
I always hate to say no, because maybe there is a way.
I suggest using INDEX and MATCH to look back to the source data to bring in relevant fields from the original source.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!