-
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…
-
Allow multiple people to see/edit DataMesh configuration
It would be very helpful if DataMesh configuration could be shared with others either for viewing or editing. There is no way for someone to see if DataMesh is being used to update data or what data is being updated other than the person who created the DataMesh. This makes support very difficult. It also makes turnover of…
-
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…
-
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…
-
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!