-
Combine emails into a multiple-contact column / multi-contact column
Multiple-contact columns can be problematic to use in Smartsheet. Namely, they cannot be "put together" with a formula. There's many use cases where you need to build multiple contacts into a cell based on criteria/lookups, but there isn't a way to do that in native core Smartsheet. There is, however, a couple of methods…
-
Merged: Datamesh roles or multiple owners
This discussion has been merged.
-
DataMesh from Report Still Pulling Filtered Rows
I have a DataMesh that is meant to pull rows from a report that excludes rows with certain criteria. Unfortunately the DM seems to pull all of the rows from the report and ignores the report's filter. Anyone else experiencing this or found a solution?
-
Send email notifications to Data Mesh config owners when a config is broken
I'm relatively new to Data Mesh, so feel free to point me in the right direction - but apparently one of my configurations was broken and I did not receive any notification that it was not working properly. I was notified by an end user that it was broken which caused me to investigate. Especially for paying a premium for…
-
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,…
-
Moving Attachments Across Sheets
I have a situation where I need to be able to move attachments across sheets as part of our workflow. I've looked into using Automation and Data Mesh and don't see how I can do this without Automation→ move row functionality. I don't want to move the whole row, just the attachments. I'm already using Data Mesh to connect…
-
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…
