Data Mesh Sync

I'm using Data Mesh to try to keep the records in a report synchronized with a target sheet. It seems to be working for adding new records to the target sheet and for updating existing records in the target sheet. However, if a record is removed from the source, I need to have it removed from my target sheet. Data Mesh recognizes unmatched records, but there isn't an option to delete unmatched records.

Any ideas how I can get Data Mesh to delete these unmatched records that are no longer in the source?

Find more posts tagged with

IT & Operations

Comments

Alejandra

Hi Jeremy,

There currently isn't a way to delete unmatched records in DataMesh. When you have a moment, submit a Product Enhancement Request to let our Product team know that you'd like to have this functionality in DataMesh.

sean59916

Yep, i'm running into the same issue!

According to https://help.smartsheet.com/articles/2476796-get-started-smartsheet-data-mesh - Smartsheet DataMesh provides lookup functionality between sheets and facilitates data consistency.

That's misleading!! Smartsheet, maybe you need a * disclaimer - unless the data is removed from the source sheet.

sean59916

Hey Jeremy -

The work around that i have at the moment is to change the source to something recognizable (like -DELETE- for example), run the datamesh to update the target sheets, then go back and delete the row in the source sheet.

You could then setup an alert or conditional format in the target sheets to show you that a row is to be deleted from the source. Hardly ideal!

See below..what did you end up doing?

Sean

Alejandra

Hi Sean,

I've submitted a request to update our Help Center article with this information. Thank you!

Geoff Baker

WOW I just bought DataMesh.

I was having the exact issue. If an Item is deleted on the source sheet it is not removed for the other pages.

DataMesh was pushed by Smart Sheet the sales team to keep our data current and accurate.

This seems like a major HOLE in that statement.

I really feel missled.

Hannah Ellis

Tagging on to this chain - it came up with a customer. Are there any updates about potentially adding this capability (delete information that no longer exists) to datamesh in the future?

Sign in to join the conversation!

Quick Links

Trending discussions

SUmmary in Report Widget
How can i create a Report widget that only shows a status with "red status" from my main data source? Do i need to create a separate data source on just my "red status"
Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…