-
Copy PARENT cell data to CHILD CELL without deleting DATAMESH field links.
Ok, I have a challenge with formulas and data being overwritten. I am trying to create a FILTER for my procurement teams to use. I ONLY want to show items where the PROCUREMENT COUNTRY is "CHINA". When I create that filter the CHILD rows do not show because the PROCUREMENT COUNTRY is "BLANK". So I need to copy the PARENT…
-
Data Mesh filter
Hello, I am trying to use a combination of Data Shuttle and Data Mesh to 1. Keep a main data set up to date and 2. Based on the region the data belongs to, allow coworkers access to specific fields. My original idea is/was to use Data Shuttle to import an employee data file to a Base Sheet. That file would be updated once…
-
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.
