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…
Deleted 5 rows from the Source sheet. Then deleted those same rows from the target sheet. The same 5 rows keep getting re-populated on the target sheet, but only the lookup values. I assume it is because I have "copy and add data" as the data mapping format in the Data Mesh settings, but that is the correct setting for my…
For Control Center to be REALLY helpful, it would be useful to be able to set up advanced functions as part of a new item being spun up. Such as creation of: WorkApps (actual WorkApps, not portfolio WorkApps DataMesh Data Shuttle Etc.
Hello Smartsheet Community, I am currently facing a challenge with the upcoming deprecation of Web Data Connector (WDC) 2.0, which impacts our integration of Smartsheet with Tableau. We have been using the Smartsheet-provided WDC available here: https://tableau.smartsheet.com/tableau. As I'm looking for guidance on how…
I'm working within gov trying to create 2 different views from the same datasets. I have a sheet for a given project that includes the staff (in rows) and the number of hours to work on that project for a given week (in columns). I have multiple sheets of this information (for multiple projects). The project view…
Hello, I'm using data mesh to bring information from other sheet(projects in this case) I have them linked with a column named "helper" I noticed that new data is not being added, however existing information is updated once a change is made in the source sheet. if I select copy and add data it adds duplicates at the end…
Error message: A JSON text must at least contain two octets! I don't do anything and the problem is gone on the next run. This is happening with multiple unrelated DataMesh configurations. I get an email alert "Scheduler Error for Config 'ConfigName' with the message: Hi, There was an issue with one of your DataMesh…
Hello Community - Has anyone found a way to copy the contents of the SHEET NAME column in a report to another Smartsheet? I was able to do it with Data Mesh but it just delivers the text content, not the hyperlink
There are several fields that are no longer in the source sheet, that I want to remove from DataMesh Config. I received a warning when it tried to run today. How can I remove these blank data fields? Thanks!
It would be helpful to use a report as a target sheet for DataMesh so you could easily update data across multiple sheets.