Data Mesh: Stop feeding Deleted Rows to Data Mesh sheet

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.

Sign in to vote!

Find more posts tagged with

Reports

Idea Submitted

DataMesh

Comments

Danielle Wilson

@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?

Quick Links

Trending ideas

Multi-Project Gantt Chart with 1 Swimlane Per Project
Our program has upwards of 50 active projects at a single time. To assist with team resourcing, we would like to view all our projects in a single Gantt chart where each project and all its phases are condensed into one row, and project phases are horizontally stacked on the same line (swimlane), rather than children in…
Form Upgrade to Pull In Data from Another Smartsheet Source
It would be extremely helpful if there was a way to have data pull into a form from another Smartsheet source based on selections made within the form. Example: On the form there is a dropdown to select a client property number. The property Name, Address, and any additional property information are then pulled into the…
Hubspot Integration for .EU instance
There is currently a Hubspot integration readily available to connect data into Smartsheet.com We have received an increased need to be able to also connect Hubspot data into smartsheet.eu Is this on the roadmap? If not this would be a great enhancements for many customers.