-
Data Mesh & Automated Sheet
I have a reference sheet that is connected to a more widely shared "Active Projects" sheet via data mesh. The reference sheet was created to be able to edit rows of the same project type in one sheet rather than dig through all active projects to make updates. The "Active Projects" sheet has an automation to be added to a…
-
Data Mesh
I set up a Data Mesh to sync contacts between 2 sheets. The goal is to sync the drop down contact list. Both columns are set to Contacts. However, when I get to the set up screen Confirm and Create, the Lookup Values field in the Source sheet is black and I can't manually add it. IT was set up correctly in the Map Sheet…
-
Data Mesh - Can you have 2 Data Mesh Configurations go into the same target sheet?
I have 2 different Smartsheets, one for design and one for construction. Each of these sheets have several different date columns that I would like to capture in a single target sheet. I can get the initial design information into the target sheet, but the construction sheet wants to create new rows instead of completing…
-
Data Mesh: Mapping incoming data to an existing hierarchy in target sheet
Hi all — I have a target sheet that has an existing year/quarter/month hierarchy: I plan to use Data Mesh to bring data from a report into this target sheet. This data will be updated fairly regularly throughout the year. I've set Data Mesh to copy and add data, based on a unique ID. Is there a way to make sure incoming…
-
Datamesh Source Missing
I set up a datamesh workflow and then when trying to run, datamesh couldn't locate the source report. I have confirmed I am an admin on the source and the target. Is this is a support issue or a me issue?
-
Feature Request: Critical Need to Allow Changing the Source Sheet in Data Mesh Configurations
Hi Smartsheet Team and Community, I would like to raise an urgent enhancement request regarding Data Mesh source sheet configuration. This limitation is causing significant operational issues for teams relying on automated updates through APIs and database integrations. 📌 The Problem When the source sheet connected to a…
-
DataMesh configuration does not run every hour
I have my DataMesh information scheduled to run every hour, but the reporting says something different. Is this common?
-
Creating lookups through control center
Hello, I believe there is a way to do what I am asking but I am just unsure how to accomplish this task. Currently in control center we have a "revenue template" and some of the data that needs to be in this sheet has to be exported from Power BI and currently we are coping and pasting the data into the revenue template…
-
Cell Links Between Sheets Don't Work Consistently
Hi - I have set data mesh cell links between multiple SmartSheets that I own. The properties of the columns on the different sheets match. In the Data Mesh set up, I've selected: To overwrite content To create cell links To run immediately I have multiple instances where data changes on the source sheet and does not update…
-
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
-
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…
-
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…
-
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?
-
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…
-
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…
-
Linking Columns of 2 Sheets to Feed into a 3rd
Hi There, I believe this should be fairly simple, however the steps are lost on me. In particular I am looking to take a single column from two seperate sheets and have them feed into a third. In this instance I am taking a Request Form (office supplies, multiple options from drop-down to cell) and an Inventory Form (cost…