-
Make DataMesh configurations editable
It would be great to go in an edit a DataMesh configuration once it's published. For example, we had to change the name of the column (made it a singular noun instead of plural) and it broke the configuration. I'm unable to go in and update the column in DataMesh so I have to great new configurations.
-
DataMesh - Make it NOT Case Sensitive
I'm having issues with DataMesh - specifically matching emails - because case matters..... I could really use a setting that allows me to specify whether I want case to matter (or just make it not case sensitive) when matching values from the source to the target. Please, oh Please!!!
-
Data Mesh Update Immediately
I have a set of sheets that I run Data Mesh on to pull relevant information over and freeze that data. I have the Data Mesh set up to Update Immediately and when I did tests on this it was pulling within 2-3 minutes most of the time. Now that time is creeping up and it takes upwards of 10-15+ minutes to pull over. Is there…
-
Bi-directional update between 2 sheets without report?
Hi, is there any workaround that allows for bi-directional updates between two sheets without the use of a report? For example, Sheet 1 has Unique ID and Status columns, same goes for Sheet 2. What I want to be able to do is if either the Status column gets updated for a project in Sheet 1 or Sheet 2, the information will…
-
Data Mesh. How to pull multiple data points based on multiple selections into one cell
Hi Everyone, I'm looking into setting up a small process that would allow my team to essentially select multiple choices from a drop down in-order to combine the various results that those selections represent in a separate sheet. The key is that we want to combine those options in a single cell. Does anyone know if this…
-
DataMesh Config : Duplicate Values in Source Sheet
I am looking for a solution/workaround for DataMesh not only to return the 1st Match currently set up in the config settings: "Duplicates in Source Sheet", but also any match that follows. I have the source sheet in which entries are fed via Form and I have set an automation "Copy to Another Sheet" when a certain criteria…
-
DataShuttle, DataMesh, Something Different--what's best
There is an excel report we get from another system that needs to be brought into SmartSheet on a weekly cadence. It is a timeline-driven document so we need the updates on dates, status, and new entries (rows) to be brought into SmartSheet. The report has this information for four teams, so we need the information from…
-
Data Mesh: Source report becomes "Not Found" after it's selected during Config creation
This is happening across multiple browsers and accounts, but just for one particular report. I can't use it in a data mesh and I'm seeing the message "Something went wrong. Please try again later." I go to New Config - Select Source sheet - and the report I want is visible, but then one of two things will happen: A. I…
-
Data Mesh Multi-Column Match
I think it would be beneficial to have a multi-line match option within a data mesh instead of having to setup 2 different configurations. For example, attempting to match the values in two columns to meet the criteria to proceed would help if you happen to have a few duplicates in one of your columns, then the secondary…
-
Enable sheet summary reports to be used in Data Mesh
Currently, reports generated using Sheet Summaries return an error message when attempting to use them in a data mesh configuration.
