Once rows from a source sheet make their way to the Data Mesh sheet, is there a way to remove them?
Answers
-
I was told that once rows from a source sheet make their way to the Data Mesh sheet, there is no way to remove them. Even though the rows may no longer exist in the source sheet, you can't prevent them from showing up again in the Data Mesh sheet. My source sheet (report) is pulling from multiple projects so it's not feasible to know what rows were deleted by project managers. I have no way of knowing what they deleted in their sheets feeding to the report, that then feeds to the Data Mesh sheet. Just want to be able to report accurately that rows in the Data Mesh sheet are active/live and not old rows that were deleted. Anyone have thoughts on this? Hopefully Smartsheet can develop a way to prevent this from happening in the future.
-
Hi @Erica L.
Yes, DataMesh "meshes" together rows, meaning it will copy rows from one item to another and link them if needed, but it does not replace the entire destination sheet or delete rows if they're deleted from the source. I see you created a Product Idea post about this, thank you!
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
Yes, hoping this can be an enhancement one day. Thank you.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives