-
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…
-
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…
-
Can I configure a DataMesh alert or email when there is a Config Log warning?
Hello Community, I what I believe to be a relatively simple data mesh between two Sheets, lots of columns in each Sheet, but the actual mapping is only about seven columns. Somehow, one of the source sheet columns had a name change. Ex. is that "Column1 " changed to "Column1" (as space was removed from the end of the…
-
Merged: Data Mesh Frequency
This discussion has been merged.