-
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…
-
Datamesh to edit a column with a Formula
hello i d like to consolidate in a sheet data coming from 2 different sheets Target sheet contains columns with Formula, and i d like to add automaticcally rows to that target sheet by using Datamesh. Columns are in same format it seems that datamesh can't create rows if one of the column has a formula. can you confirm ?…
-
DataMesh - Always add a new row
I'm trying to use datamesh where I want it to always add a new line to the target sheet, even if the Lookup Value is a duplicate. When I add a new line to the source sheet, if the lookup value is unique, it will successfully copy over to the target, but if it is a duplicate, it doesn't do anything. How could I achieve this?