Match Contact column list to Email Address
Has anyone found a practical solution to match a Contact column to an email address? It can't be done in DataMesh and while I've done some searching on the board and help files, I haven't found a method to do this that doesn't require a lot of manual intervention. The problem with Smartsheet Contacts is that people can…
Multiple Updates to a Single Row
Hello, I am trying to create a "tracker" that show the progress of a shipment that contains multiple steps that are updated as each step is complete. So essentially the Tracker sheet would pull all the new entry submissions and update submissions from the dump sheet, to one row on the Tracker for each shipment. There are…
Random Data showing up when using Data Mesh
I have Data Mesh set up to put in a "Type 2" for a loan type when the "Type" is put in. After copying and pasting the data that shows the "Type" of loan, the "Type 2" is automatically updated and also extra data is automatically put in when it shouldn't be at the bottom of the sheet. In the image below, the data that lists…
Is there a way to use Datashuttle on a report?
Hello all, I have a report that I want to export into a google sheet, however, I am unable to find the report when I use the Datashuttle process. If this is not possible, is there a way to import the range from the report to a normal sheet? I have already tried Datamesh but I wasn't able to get it to work. Any help is…
DataMesh error. Failed to issue the request. Error code: 504. GATEWAY_TIMEOUT
Hello, I have been running a DataMesh for a few months and have started getting the error below. Does anyone know what could be causing this? Error message Error! Failed to issue the request, please relogin and try again. Error code: 504 - Error message:GATEWAY_TIMEOUT Grid sizing Source: 49 columns 3,631 rows 177,919…
Can we duplicate Datameshs ?
Hello, Every week I need to load a new set of refreshed datapoints from Excel to Smartsheet Then I have to recreate the datamesh I used in the past week to take into account this fresh load of data jsut uploaded. I need to do this 3 times as there are 3 sheets that leverage this refreshed set of data Can you think about a…
Data Mesh or Formula - what takes precedence
I have taken ownership of a sheet which is updated by a Data Mesh. I do not have access to the Data Mesh and the person who does is not currently available to transfer it to me or delete it. I changed the columns being updated by the Data Mesh to use lookup formulas because I need the report to update immediately. The Data…
Integrating DataMesh Config Into Control Center Blueprint
Hello! Does anyone know if you can build a DataMesh config into your blueprint in Control Center? I've got a standard DataMesh setup that I'd like to run between templated sheets. It would be excellent if I could build this into my blueprint and bypass setting up a new config every time.
Pull information from report to sheet
Hello, I have a template that my team uses for data collection each time we get a new lot of diagnostic tests we need to quality check. In one folder, "data collection forms" there are many sheets, as each lot gets it's own sheet. New lots are tested every day, so the sheets in this folder are constantly being added to. We…
How can I activate Datamesh
Morning all Can`t seem to find a website that tells you how to download Datamesh. Please let me know off one or tell me how to download Datamesh Many Thanks