-
Allow Adding Multiple Source Sheets in Data Mesh
Hi Team Recently in the new update we are able to add up to 5 destination sheets in the data mesh which has become very useful. In the same way will it be possible to allow adding multiple source sheets also in one mesh. This will be very helpful in reducing the number of meshes for a particular task
-
Auto delete rows flagged as duplicate or missing
I have a 2-part question: Setup - we use a master sheet that uses data mesh to populate 3 other sheets based on a primary key. This works well. However, there is alot of manual cleanup. part 1 - If a row is deleted from the main sheet, I would like it removed from the other 3 vs. me highlighting it for manual deletion, an…
-
Is it feasible to automatically transfer input from form data with added formatting and information?
Hi, I am attempting to reduce the need for manual data entry. Essentially, I would like a system where a sales colleague can check off a list of processes when they receive an order, lets say A, B, and C. A new sheet is created for production showing they need to complete processes A B C. The problem I am facing is that I…
-
Datamesh issue with updating cells in a parent row
Cells in a parent row are not getting updated using Datamesh. Are there any rules for this? There are no Lookups etc.
-
combining two smartsheets into one new
I have access to two Smart sheets that my colleague updates, can I create a joined sheet which I will own but the data will come two the two other sheets?
-
hello, I need help with data mesh automation
How do I make data mesh automatically update from the report it is coming from? I have to continuously delete all in the mesh, re-add the vlookup value it looks for to mesh. I need it to update at least once per day on it's own.
-
Can you integrate DataMesh into Control Center blueprints?
Back in 2021 this wasn't possible. Has Smartsheet added the ability to create DataMesh configs that are automatically created when a blueprint is used to spin up a project with Control Center? This would be so nice.
-
DataMesh is defaulting to Column mapping instead or Row mapping
Totally perplexed. I've used DataMesh to map rows once I selected the columns in which the identifiers are. But for some reason, now DataMesh is leading me to map Columns only, not rows. It's like it's configured for an HLOOKUP rather than a VLOOKUP. Anyone know how this could happen? It feels like a setting issue of some…
-
How do I import an entire column from one sheet to another without getting #unparseable
I need all of the information entered in a column of sheet A to feed into sheet B. Does anyone have any advice for this? This is the current formula we're trying that's showing up as unparseable: "=INDEX({A. Wash Schedule Range 1}, MATCH({A. Wash Schedule Range 1}),@row, 0)" We're gotten "=INDEX({A. Wash Schedule Range 1},…
-
Data Mesh 4004 Error
I'm curious if anyone else has run into this Data Mesh error, and if they understand why it occurs: I receive this error periodically on multiple configs. It doesn't happen often enough that it has caused any noticeable issues, and I've never seen it happen two times in a row, so this hasn't impacted our users. I want to…
