How to Automatically Sync Row Deletions Between Linked Sheets in Smartsheet?
Hi Smartsheet Community,
I need some assistance with syncing linked sheets. I have set up Cell Linking between multiple sheets, and the data updates are working fine—when I change the data in the source sheet, the linked columns in the destination sheet update as expected.
However, I’ve run into an issue when I delete rows in the source sheet. The data in the linked cells remains intact in the destination sheet, even though the row no longer exists in the source sheet.
Is there a way to automatically remove or delete the corresponding rows in the destination sheet when they are deleted in the source sheet? I’m looking for a solution that keeps both sheets fully synchronized, not just for data changes but also for row deletions.
Any suggestions for automating or achieving this would be greatly appreciated! I'm open to using automations, formulas, or any integrations that could help.
Thanks in advance for your insights!
Answers
-
Is there a reason you are using cell linking instead of reports?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@Paul Newcome I need to show the metrics in the Dashboard and they're not allowing the reports for metrics. So I'm using another sheet for that because i don't want my main file to have all those caluclations etc.
-
I'm not sure I follow. Are you able to provide some screenshots for context?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 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
- 284 Events
- 33 Webinars
- 7.3K Forum Archives