-
dynamic reference/dynamic linking from another sheet
I want to link a cell from sheet B to sheet A, where the column name in sheet B is determined by a string in sheet A. i.e. "sheetA_string" is dynamic, and matches a column header in sheet B. Datamesh does not allow dynamic column linkages. (this would be ideal). I'm currently using index( match( {find row} ), match( {find…
-
Drop PDF to populate rows
As a sourcing analyst I have to take multiple pricing summaries from our consultants and enter the information into our Smartsheet. Currently that means a lot of copy and pasting and painful data entry. My question: Is there a way I can take the PDF they send me and drop it in Smartsheet and it auto populate my sheet based…
-
How to stop DataMesh breaking % Complete parent row roll-up calculations?
I am trying to use DataMesh to populate my % Complete column using a helper column that provides % completion based on the Status column (because my PM doesn't want their employees to have to enter percentages, but rather statuses). I have the DataMesh config set to copy what's in the helper cell into % Complete. In the…
-
Quarterly Planning - Looking to improve collecting team responses
I am in the PMO for a large engineering organization. Currently we have a large portfolio sheet (Control Center Summary sheet) that captures all of the information about each project. In our quarterly planning process, for each project we have the PM input their scope and select which development teams they need support…
-
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…
-
Merged: Allow multiple people to see/edit DataMesh configuration
This discussion has been merged.
-
Combine Multiple Sheets with Live Data using Data Mesh
I have 5 Metric Sheets that come from a Master form sourced sheet. I want to combine the 5 Metric Sheets into one Master Metric sheet that updates live WITH the formulas that are already in the metric sheets. I have combined all 5 Metric Sheets into one Master Metric Report and tried Data Mesh, into a blank Master Metric…
-
Easier way to identify and transfer Premium App Assets from one user to another for System Admin
Currently there is no easy way to identify what premium app assets was created by the user who is leaving the company. (or left the company) System admin is not able to view assets created by the user for DataMesh Pivot Workapp System admin can view asset created by user but unable to transfer ownership: Data Shuttle Some…
-
Data Mesh multiple target sheets - Cell Max Limit Error
Hello all, hoping to get some input here or curious if anyone has had experience with this. Currently have a datamesh set up looking at Report (Source Sheet), that sends about 28 columns to 1 Data Processing sheet (target sheet) based off of a UID. This target sheet hits it cell limit a couple times a year and we have to…
-
How do companies manage and document data flows in Smartsheet to ensure data integrity?
I’m new to Smartsheet and data meshing, and I’ve noticed that the original source data isn't always used consistently. For instance, someone might create a data mesh from a source to build their own sheet (Sheet B). Then, another person creates a data mesh from Sheet B, and this process continues. How do companies manage…
