-
Allow DataMesh to Update more than 5 Targets
Often we have multiple target sheets that are identical to one another - differing only to manage access to data to specific audiences. All, or most, of the columns are identically named and the sheets will share master data. Currently a DataMesh can only be linked to up to five Target Sheets. Please remove this 5 sheet…
-
Data Mesh: Copy Data vs Create Cell Links?
I am new to Data Mesh and I believe it is the answer to many projects I have. I am looking for more information/explanation regarding whether to choose Copy Data or Create Cell Links? It appears in my testing that they function the same. What am I missing? Thank you!
-
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…
-
Datamesh to populate links to sheets
Hello, I have a Datamesh that: Reads a row-report gathering several sheets Looks to feed a separate sheet with the link to each of the sheets gathered in the above report. For that matter I've setup the Datamesh with 'Data Mapping Format' = "Create Cell Links" This Datamesh has 1 field (in addition to the lookup values):…
-
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…
-
Allow for Multiple Lookup Values in DataMesh
