数据网格同步
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?
Comments
-
Alejandra EmployeeHi Jeremy,
There currently isn't a way to delete unmatched records in DataMesh. When you have a moment, submit aProduct Enhancement Requestto 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 tohttps://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 Employee
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 Employee
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?
Categories
You would use the below for Jan 2023 and adjust the month and year numbers accordingly for each of the other months.<\/p>
=IF(AND(MONTH([Start Date]@row)<= 1, YEAR([Start Date]@row)<= 2023, MONTH([End Date]@row)>= 1, YEAR([End Date]@row)>= 2023), [$ per month]@row)<\/p>"},{"commentID":387901,"body":"
Lets try a different approach.<\/p>
=IF(AND(VALUE(YEAR([Start Date]@row) + IF(MONTH(Start Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/51951/\") + MONTH([Start Date]@row))<= 202307<\/strong>, VALUE(YEAR([End Date]@row) + IF(MONTH([End Date]@row)< 10, \"0\", \"//www.santa-greenland.com/community/discussion/51951/\") + MONTH([End Date]@row))>= 202307<\/strong>), [$ per month]@row)<\/p> Basically we are creating a yyyymm stamp from the start and end dates and comparing them to the yyyymm stamp for that year\/month combo. The above is for July 2023 (202307).<\/p>"},{"commentID":387906,"body":"
<\/p>
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/G1SDKXPQ7I1D\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/GCQ7U05Q4GNO\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/79GD9D2EWXCW\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
