-
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: 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…
-
Datamesh Archiving
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.…
-
Data Mesh Only adding new information
Hi, I have one sheet of customer names and one sheet of customer information. Both sheets have customer ID's. The customer information is the source sheet and the customer name target sheet. I want information from the customer information added to the customer name sheet "only" if it a new customer ID. I want it to skip…
-
Use DataMesh to combine multiple sheets
I'm trying to combine multiple sheets into one master list, what is the best way do the config for this please? I want it to pull in all values from source sheets, and if the source sheets gets updated I want it to automatically update the master target sheet. Sometimes the source sheets have duplicates so I want it to…
-
Clear a Sheet on a Schedule
Hello lovely community, I need some help figuring out the best mechanism for clearing a sheet on a schedule. It really should be easier than this! I have tried the following methods, and outlined the limitations and issues below. I would LOVE to get some suggestions for other methods! Problem: I need to fully clear (delete…
-
How is an existing DataMesh configuration edited to add more target sheets?
What are the steps or are the no steps to add more sheets to Step 2 - Select Target Sheet(s) for an existing configuration. I've clicked the gear, clicked previous but cannot get back to the Step 2 to add more target sheets. Help please or is this not an option for this feature? Thank you!
