-
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,…
-
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…
-
Add "Notes" attribute to meshes and pivots
It can be difficult to track the full flow of a process from end to end via meshes and pivots. If a new "notes" attribute could be added to both mesh and pivot configurations, the users could add some brief documentation to help later maintenance/tracing.
-
Help Article updates July 2025
Hello Community, We’ve published the following new content. New videos on these topics: Smartsheet Permissions and Sharing in Sharing permission levels and tasks How to create a Sheet Summary Report in Create a sheet summary report How to create a Row Report in Build a row report And these new best practices: DataTable…
-
DataMesh Question
I have a DataMesh pulling from over 300 sheets and updating the rows every hour. I want to add a column on the DataMesh, not on the individual sheets, to track the status of each row. If I add a new column on the DataMesh will this break it?
-
How to manage large data set uploads without Data Shuttle or DataMesh when creating a SCC Blueprint?
I have a client who has a Smartsheet commercial plan and just migrated to Microsoft GCCH. I know DataMesh is not directly integrated with Smartsheet Control Center (SCC). Because the client does NOT have a Smartsheet Gov plan, they are NOT able to utilize Data Shuttle if the source is OneDrive/SharePoint. Does anyone have…