-
Data Mesh Update Immediately
I have a set of sheets that I run Data Mesh on to pull relevant information over and freeze that data. I have the Data Mesh set up to Update Immediately and when I did tests on this it was pulling within 2-3 minutes most of the time. Now that time is creeping up and it takes upwards of 10-15+ minutes to pull over. Is there…
-
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,…
-
Bi-directional update between 2 sheets without report?
Hi, is there any workaround that allows for bi-directional updates between two sheets without the use of a report? For example, Sheet 1 has Unique ID and Status columns, same goes for Sheet 2. What I want to be able to do is if either the Status column gets updated for a project in Sheet 1 or Sheet 2, the information will…
-
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…
-
Data Mesh Ownership Transfer in the absence of the Owner
Hi all, In our organization, there are a few Data Mesh’s which connect different Smartsheets. Unfortunately, the owner of these Data Meshs is out sick and therefore, cannot make changes that are needed to be made to them. Question: How can we gain access to the Data Meshs which another person in the organization holds…
-
Data Mesh. How to pull multiple data points based on multiple selections into one cell
Hi Everyone, I'm looking into setting up a small process that would allow my team to essentially select multiple choices from a drop down in-order to combine the various results that those selections represent in a separate sheet. The key is that we want to combine those options in a single cell. Does anyone know if this…
-
DataMesh Config : Duplicate Values in Source Sheet
I am looking for a solution/workaround for DataMesh not only to return the 1st Match currently set up in the config settings: "Duplicates in Source Sheet", but also any match that follows. I have the source sheet in which entries are fed via Form and I have set an automation "Copy to Another Sheet" when a certain criteria…
-
DataShuttle, DataMesh, Something Different--what's best
There is an excel report we get from another system that needs to be brought into SmartSheet on a weekly cadence. It is a timeline-driven document so we need the updates on dates, status, and new entries (rows) to be brought into SmartSheet. The report has this information for four teams, so we need the information from…
-
Data Mesh Administration
When a user's Smartsheet license is removed we are currently unaware if a person has any configs in Data Mesh. When a person is deleted or license removed, these configs should go to an escrow account like we do currently with sheets. We just learned someone had configs and fortunately the person's ID had not been deleted…
-
Data Mesh: Source report becomes "Not Found" after it's selected during Config creation
This is happening across multiple browsers and accounts, but just for one particular report. I can't use it in a data mesh and I'm seeing the message "Something went wrong. Please try again later." I go to New Config - Select Source sheet - and the report I want is visible, but then one of two things will happen: A. I…