-
Create report OR DataMesh to pull information from MetaData Worksheets
I have a client ask for a report. There are 150+ stores involved in the report. MOST of the information I need for the report can be found in each of the MetaData sheets. The challenge however, is that the MetaData sheets are buried two folders deep in the Workspace. How do I either create a report or a DataMesh that will…
-
Will a new Smartsheet saved with the name of a Source Sheet still work with DataMesh?
Looking to save some time by replacing old information within a Source Sheet with information housed within another Smartsheet. Can I relabel the original source sheet to an obsolete name and save the new Smartsheet with the source sheet's name and keep all the connections working with DataMesh?
-
Pause / Hold DataMesh
As far as I can see, there is no way to pause / put on hold a DataMesh once it is created or even during the development process. It seems that you'd have to create the DataMesh to prove the concept; then, if not wanting it to function right away, you'd have to delete it only to re-create it when you are ready to implement…
-
From a DataMesh, can I link data from my Target Sheet back to my Source Sheet?
I know there is a way to "Overwrite Existing Data in Target Sheet(s)" but is there a way for the updates to flow in the opposite direction? I want to send a "request an update" from my Target Sheet. I am sending this from my Target sheet and not my Source sheet because I want additional columns not on the Source Sheet. I…
-
Merged: Add more than one admin to DataMesh configurations
This discussion has been merged.
-
Very Small Sheet causes "Error! Failed to issue the request,
I use Datamesh to update from one sheet to another and then back again. Been successful with these two sheets for a year. Suddenly I'm getting the errors: Error! Failed to issue the request, please relogin and try again. Error code: 0 - Error message:error This only happens one direction. I can datamesh from Sheet A to…
-
Data Mesh Timing & Owner status in Activity Log
1st Question: Does the hourly option work based an hourly run? Or is it triggered an hour from the latest change? 2nd Question: If someone created the Data Mesh and then transfers ownership to you, does it show both of your names when the workflow is run for that app in the Activity Log?
-
Pulling in selected data from another sheet when conditions are met & then marking that as used
I have a complicated use case I could use some help with. Apologies if I'm using the wrong words here; happy to provide clarification. Here's what I'd like to happen: User submits a form to request a voucher for a specific exam. Row in SmartSheet 1 is populated with user's data. Upon row population, another sheet…
-
DataMesh Error 5118: An unexpected error has occurred running your report...
Hi, I have an error appearing on DataMesh where the source report has been wiped and now the DM cannot run. The source report initially crashed, which is what I believe wiped out the source from the DM, however the source report is up and running again. I know that I can recreate a new DM, but is there a way to bring the…
-
Data Meshing from a report to another sheet wipes out the data
I created a reported and I then exported that report into Excel and then uploaded that Excel into Smartsheets as it's own sheet. I want to be able to data mesh from the report to the target sheet, but even though it's identical information when I data mesh it wipes out all of the information from my Assigned To column.…