How do I get Datamesh to create new rows when lookup values match, but mapped columns have different
I've created a form which collects some common data, and then multiple requests, each with their own data. For example, I'm collecting the requestor's name, and 25 bits of data they want added into our system. The 25 bits of data all share the same properties, but it's very unwieldy to have all on a single row in the…
Data Shuttle or other solution?
Hello, I am trying to figure out the best solution to a project. Basically, we have a system outside of Smartsheet that will not connect to Smartsheet (old system) and we do not want to pay to integrate them. I want to manually upload exports from the legacy system (.CSV files) into a preformatted Smartsheet sheet on a…
Ownership of DataMesh and DataShuttle Processes
Hey There - I have a number of DataMesh/DataShuttle processes that I've setup, and realizing that our team does not have access to them b/c it's under my account. I assume others have run into this problem in the past, interested in how others have handled this situation? Is there a delegation feature of sorts?
add data with hours - formula or something else
Como que eu faço para somar datas com horas exemplo (18/04/2023 15:00:00 - 06/04/2023 13:00:00 ??) Translated by Moderator How do I add data with hours for example (04/18/2023 15:00:00 - 04/06/2023 13:00:00 ??)
Data Mesh Update Immediately
I have a set of sheets that I run Data Mesh on to pull relevant information over and freeze that data. I have the Data Mesh set up to Update Immediately and when I did tests on this it was pulling within 2-3 minutes most of the time. Now that time is creeping up and it takes upwards of 10-15+ minutes to pull over. Is there…
Data Mesh: Source vs Target sheets
Hi all, I'm creating a work flow to integrate a number of services that my team offers. There is a work sheet that captures all projects sent our way and assigns them to 1 to 3 services - and those projects show up on their respective work sheets via Data Shuttle. Currently - I have cross sheet formulas set up such that…
It would be great to have a DataMesh archive button so that we could archive old datamesh, assess if there's any unwanted impact before the datamesh is auto-retired/deleted within 30-60 days. It would save the worry of accidently deleting a DataMesh that a user incorrectly presumes is no longer required.
Remove Rows That Are No Longer In Report
I've done a little bit of research and from what I'm seeing there isn't a way (but I'm hopeful you all have a workaround 😀). So I have sheets that contain multiple unique IDs for tasks (they are separated out by manager since we have so many of them) and if a task is deleted on a project plan because it isn't needed…
Configuring multiple sheets to all update each other in datamesh
Hello there, I am trying to configure datamesh to work between a parent sheet and its children. I have a master sheet with like information, and an automation that copies rows to child sheets (which all contain the like information and additional information based off of departments) and am trying to link the like…
Best Way to Pull A Ton of Data
Hello Community, I have recently been given the challenge of pulling a ton of data from a source sheet to a target sheet, and am trying to figure out the best way to pull all the data efficiently and not run out of space too quick. Unfortunately we cannot use data mesh because each row has 7 target columns to pull from.…