-
Datamesh roles or multiple owners
Incorporating Datamesh roles or multiple owner capabilities into Smartsheet would significantly enhance its functionality and collaborative potential. Datamesh roles would allow for more granular control over data access and manipulation, ensuring that team members can interact with the data in ways that align with their…
-
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…
-
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.
