-
Can I use DataMesh so I can update in either sheet?
I'm very familiar with Smartsheet but far less so with DataMesh so I'm just looking for confirmation on whether what I'm looking for is possible We have 2 sheets, Intake A & Intake B. At a certain point, we copy the row from Intake A to Intake B to create/track a different project. Because of that, Intake B has all the…
-
Formula columns not updating automatically after data is pulled in via datamesh
We discovered that our formula columns are not updating automatically after data is pulled in via datamesh and they only update if someone goes into the sheet, clicks into some cells, then saves the sheet. Support told me to set up an automation on the sheet that does something like locking then unlocking a specific cell…
-
Datamesh batching process
Is it possible to batch run Datamesh configs so they run in a specific sequence to update a master sheet? I have a master list of action items need to be updated in a specific order.
-
Allow DataMesh to Update more than 5 Targets
Often we have multiple target sheets that are identical to one another - differing only to manage access to data to specific audiences. All, or most, of the columns are identically named and the sheets will share master data. Currently a DataMesh can only be linked to up to five Target Sheets. Please remove this 5 sheet…
-
Data Mesh: Copy Data vs Create Cell Links?
I am new to Data Mesh and I believe it is the answer to many projects I have. I am looking for more information/explanation regarding whether to choose Copy Data or Create Cell Links? It appears in my testing that they function the same. What am I missing? Thank you!
-
Allow DataMesh to Update Multiple Targets
Often we have multiple sheets that are identical to one another - differing only by region, product or project. All, or most, of the columns are identically named and the sheets will share master data. Currently a DataMesh can only be linked to one Target Sheet. It would be terrific if multiple target sheets could be…
-
Datamesh to populate links to sheets
Hello, I have a Datamesh that: Reads a row-report gathering several sheets Looks to feed a separate sheet with the link to each of the sheets gathered in the above report. For that matter I've setup the Datamesh with 'Data Mapping Format' = "Create Cell Links" This Datamesh has 1 field (in addition to the lookup values):…
-
dynamic reference/dynamic linking from another sheet
I want to link a cell from sheet B to sheet A, where the column name in sheet B is determined by a string in sheet A. i.e. "sheetA_string" is dynamic, and matches a column header in sheet B. Datamesh does not allow dynamic column linkages. (this would be ideal). I'm currently using index( match( {find row} ), match( {find…
-
Drop PDF to populate rows
As a sourcing analyst I have to take multiple pricing summaries from our consultants and enter the information into our Smartsheet. Currently that means a lot of copy and pasting and painful data entry. My question: Is there a way I can take the PDF they send me and drop it in Smartsheet and it auto populate my sheet based…
-
How to stop DataMesh breaking % Complete parent row roll-up calculations?
I am trying to use DataMesh to populate my % Complete column using a helper column that provides % completion based on the Status column (because my PM doesn't want their employees to have to enter percentages, but rather statuses). I have the DataMesh config set to copy what's in the helper cell into % Complete. In the…
