-
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…
-
Data Mesh Multi-Column Match
I think it would be beneficial to have a multi-line match option within a data mesh instead of having to setup 2 different configurations. For example, attempting to match the values in two columns to meet the criteria to proceed would help if you happen to have a few duplicates in one of your columns, then the secondary…
-
Use Data Mesh to Move Attachments/Comments Between Sheets
It would be fantastic if we could move comments from one sheet another, but ESPECIALLY helpful would be the ability to use Data Mesh to move/merge attachments.
-
Enable sheet summary reports to be used in Data Mesh
Currently, reports generated using Sheet Summaries return an error message when attempting to use them in a data mesh configuration.
-
Datamesh to edit a column with a Formula
hello i d like to consolidate in a sheet data coming from 2 different sheets Target sheet contains columns with Formula, and i d like to add automaticcally rows to that target sheet by using Datamesh. Columns are in same format it seems that datamesh can't create rows if one of the column has a formula. can you confirm ?…