-
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…
-
Can you cell link through Bridge?
Hello, I have used DataMesh to create links. However, is it possible to use Bridge and create cell links when adding row. Instead of a write in it would be linked. If possible how would i get the link information to reference.
-
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
-
How to copy all data from outside Control Center to new sheets?
My original process has almost 200 sheets outside of Control Center. I've recently setup a Control Center workflow and generated the same sheets based on the same template I was using outside of Control Center. How can I automate copying the data from the old sheets into the new sheets? I have access to Data Mesh and Data…
-
DATAMESH - ONE DROPDOWN COLUMN DOES NOT UPDATE
Hi, I am wondering what should I do. I have 11 specifics sheet updating the mastersheet for 5 columns. everything updates except my status column. there is no formula in that column it is a dropdown column with 4 differents choices. my datamesh is built with update immediately all fields are well set up. I have cell link…
-
Datatable Lookup Mode: Checkbox if no Unique Identifier Value was found in the Datatable
I'm using a Datatable Lookup to populate rows on a sheet. Is there any way to add a checkbox automatically if the system found no result of the Unique Identifier in the datatable? To be clear, I mean the value in that Row's "Sheet Unique Identifier" column was not found, and NOT that it found it but the mapped columns…
-
Allow Adding Multiple Source Sheets in Data Mesh
Hi Team Recently in the new update we are able to add up to 5 destination sheets in the data mesh which has become very useful. In the same way will it be possible to allow adding multiple source sheets also in one mesh. This will be very helpful in reducing the number of meshes for a particular task
-
Auto delete rows flagged as duplicate or missing
I have a 2-part question: Setup - we use a master sheet that uses data mesh to populate 3 other sheets based on a primary key. This works well. However, there is alot of manual cleanup. part 1 - If a row is deleted from the main sheet, I would like it removed from the other 3 vs. me highlighting it for manual deletion, an…
-
Is it feasible to automatically transfer input from form data with added formatting and information?
Hi, I am attempting to reduce the need for manual data entry. Essentially, I would like a system where a sales colleague can check off a list of processes when they receive an order, lets say A, B, and C. A new sheet is created for production showing they need to complete processes A B C. The problem I am facing is that I…
-
Datamesh issue with updating cells in a parent row
Cells in a parent row are not getting updated using Datamesh. Are there any rules for this? There are no Lookups etc.
-
combining two smartsheets into one new
I have access to two Smart sheets that my colleague updates, can I create a joined sheet which I will own but the data will come two the two other sheets?
-
hello, I need help with data mesh automation
How do I make data mesh automatically update from the report it is coming from? I have to continuously delete all in the mesh, re-add the vlookup value it looks for to mesh. I need it to update at least once per day on it's own.
-
How do I import an entire column from one sheet to another without getting #unparseable
I need all of the information entered in a column of sheet A to feed into sheet B. Does anyone have any advice for this? This is the current formula we're trying that's showing up as unparseable: "=INDEX({A. Wash Schedule Range 1}, MATCH({A. Wash Schedule Range 1}),@row, 0)" We're gotten "=INDEX({A. Wash Schedule Range 1},…
-
Data Mesh 4004 Error
I'm curious if anyone else has run into this Data Mesh error, and if they understand why it occurs: I receive this error periodically on multiple configs. It doesn't happen often enough that it has caused any noticeable issues, and I've never seen it happen two times in a row, so this hasn't impacted our users. I want to…