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.
@Erica L. As a thought, maybe you could create an archive sheet and having a column that checks if the unique ID is present on the original sheet, and if it's not there (i.e. you have a checkbox or something), that could act as the trigger for an automation to move that row over to the archive sheet?
Danielle W.
Product Marketing
Smartsheet