-
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…
-
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.
-
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…
-
Feature Request: Critical Need to Allow Changing the Source Sheet in Data Mesh Configurations
Hi Smartsheet Team and Community, I would like to raise an urgent enhancement request regarding Data Mesh source sheet configuration. This limitation is causing significant operational issues for teams relying on automated updates through APIs and database integrations. 📌 The Problem When the source sheet connected to a…
-
Datamesh Source Missing
I set up a datamesh workflow and then when trying to run, datamesh couldn't locate the source report. I have confirmed I am an admin on the source and the target. Is this is a support issue or a me issue?
-
Creating lookups through control center
Hello, I believe there is a way to do what I am asking but I am just unsure how to accomplish this task. Currently in control center we have a "revenue template" and some of the data that needs to be in this sheet has to be exported from Power BI and currently we are coping and pasting the data into the revenue template…
-
Change the source sheet on Data Mesh
I've just started with Data Mesh and my only problem is not being able to change the source sheet. There is often new informational sheets I need to update and instead of having to make a new Data Mesh and delete the old one, it would be nice to be able to change the source sheet to reflex our changes. Thanks