-
Using Datamesh then want to cell link to source so updates will appear in target
I am using a master project list, filtering out certain jobs with a report, then using DataMesh to move the jobs onto a Intake sheet. I then want to cell link critical data from the source into the Intake sheet so any updates from the Master are reflected in the target sheet. I create the Inbound cell link, but when a new…
-
Help with Data Mesh issue
I am trying to Data mesh a report summary to a sheet so i can show KPIs for multiple project sheet summaies onto my dashboard. I am getting the attached error code whenever i select the sheet summary report for the the mesh. 1. why am i getting this error, can i use sheet summary report as a source for data mesh? FYI - i…
-
Please Allow Multiple Admins for DataMesh
Our team is really struggling to troubleshoot issue when the owner of a DataMesh or Data Shuttle is out of the office. Please allow multiple Admins and/or Editors (or, at the very least, Viewers) for these critical tools.
-
DataMesh Note Section
Within DataMesh it would be really helpful to include an additional field to provide a description of what workspace/purpose etc. that the DataMesh config is applicable to. Currently I have ~50 configs for various workspaces. I have come up with a naming structure however I am limited to how much space I can use.
-
What is the best practice for referencing data in another sheet?
I currently have a Data Shuttle updating/replacing all cells in sheet 1. In a second sheet I have a formula that performs an Index/Match with the result coming from that first sheet. I noticed the cell history on the second sheet is capturing the first sheet values disappear and then come back in (example below). Assuming…
-
Data Mesh & Automated Sheet
I have a reference sheet that is connected to a more widely shared "Active Projects" sheet via data mesh. The reference sheet was created to be able to edit rows of the same project type in one sheet rather than dig through all active projects to make updates. The "Active Projects" sheet has an automation to be added to a…
-
Combine emails into a multiple-contact column / multi-contact column
Multiple-contact columns can be problematic to use in Smartsheet. Namely, they cannot be "put together" with a formula. There's many use cases where you need to build multiple contacts into a cell based on criteria/lookups, but there isn't a way to do that in native core Smartsheet. There is, however, a couple of methods…
-
Data Mesh
I set up a Data Mesh to sync contacts between 2 sheets. The goal is to sync the drop down contact list. Both columns are set to Contacts. However, when I get to the set up screen Confirm and Create, the Lookup Values field in the Source sheet is black and I can't manually add it. IT was set up correctly in the Map Sheet…
-
Data Mesh: Mapping incoming data to an existing hierarchy in target sheet
Hi all — I have a target sheet that has an existing year/quarter/month hierarchy: I plan to use Data Mesh to bring data from a report into this target sheet. This data will be updated fairly regularly throughout the year. I've set Data Mesh to copy and add data, based on a unique ID. Is there a way to make sure incoming…
-
Data Mesh - Can you have 2 Data Mesh Configurations go into the same target sheet?
I have 2 different Smartsheets, one for design and one for construction. Each of these sheets have several different date columns that I would like to capture in a single target sheet. I can get the initial design information into the target sheet, but the construction sheet wants to create new rows instead of completing…