-
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…
-
DataMesh not bringing over 0d when linking 2 project plans
I am using DataMesh to bring in tasks from one project plan to another. DataMesh is bringing over [Task Name], [Start Date] and [Duration], using a unique ID column as the Lookup Value This works very well unless the source sheet has a duration of 0 days. If the source sheet has 0d in [Duration] it will lead to a blank…
-
DataMesh and WorkApps in smartsheetgov
Both of these apps are available in the commercial smartsheet.com version but not in the SmartSheetGov version. Will be very helpful if these are also made available in the GOV version of SmartSheet