-
Please Allow Multiple Admins for DataMesh
Our team is really struggling to troubleshoot issue when the owner of a DataMesh or Data Shuttle is out of the office. Please allow multiple Admins and/or Editors (or, at the very least, Viewers) for these critical tools.
-
Use a Report as a Target for DataMesh.
It would be helpful to use a report as a target sheet for DataMesh so you could easily update data across multiple sheets.
-
Datamesh can pull from a formula column?
In my source report being used for a datamesh I have a column that is a formula column with a nested IF statement. The destination sheet is set-up to be a text/number field. Other columns work on the same source report are meshing, the one that is a column formula is not…is that the issue here? Thank you
-
Using DataMesh to Split One Line Onto Multiple Lines (for Forms Entries and Other Uses)
This is a problem I've heard a few times so I'm answering it in a separate post for reference in long form. I'm using the example from @WtaylorW's question over here. The basic need is to take one line and split it onto multiple lines. In this example you have a form that's inputting multiple names in different columns,…
-
Integrate DataMesh with Control Center
I have a lot of use cases where it would be so helpful if I could provision DataMesh workflows when projects are provisioned through control center. There is no way to copy a data mesh workflow, so if I need one created for a project, I have to recreate the entire workflow, every time.
-
DataMesh: Updates ALL rows, not only the changed row
It used to be that DataMesh would copy data from one cell to another per row. Lately, it has changed to updating an ENTIRE COLUMN if the value in ONE ROW changes. So instead of "1 row affected", it always thinks ALL rows are affected even if no changes are made to the other rows. This then triggers notification automations…
-
Match Contact column list to Email Address
Has anyone found a practical solution to match a Contact column to an email address? It can't be done in DataMesh and while I've done some searching on the board and help files, I haven't found a method to do this that doesn't require a lot of manual intervention. The problem with Smartsheet Contacts is that people can…
-
DataMesh: What if the lookup value column is a formula?
I have a sheet to track travel, which includes a Start Location column and End Location column, and a third "Start - End" column which contains a formula that combines the first two columns. I've done this so that I can reference another sheet, which has the estimated cost from Location A to B, using DataMesh. However,…
-
DataMesh Note Section
Within DataMesh it would be really helpful to include an additional field to provide a description of what workspace/purpose etc. that the DataMesh config is applicable to. Currently I have ~50 configs for various workspaces. I have come up with a naming structure however I am limited to how much space I can use.
-
Data mesh: Merging between sheets
I have 3 sheets: 2 of them have their own forms to collect data, and 1 master sheet. The 2 individual sheets have questions which are similar to each other and questions which are completely different (they are 2 forms of questionnaires). The master sheet is used to merge the answers of the similar questions and all other…