-
How to copy all data from outside Control Center to new sheets?
My original process has almost 200 sheets outside of Control Center. I've recently setup a Control Center workflow and generated the same sheets based on the same template I was using outside of Control Center. How can I automate copying the data from the old sheets into the new sheets? I have access to Data Mesh and Data…
-
Datamesh to populate links to sheets
Hello, I have a Datamesh that: Reads a row-report gathering several sheets Looks to feed a separate sheet with the link to each of the sheets gathered in the above report. For that matter I've setup the Datamesh with 'Data Mapping Format' = "Create Cell Links" This Datamesh has 1 field (in addition to the lookup values):…
-
Datatable Lookup Mode: Checkbox if no Unique Identifier Value was found in the Datatable
I'm using a Datatable Lookup to populate rows on a sheet. Is there any way to add a checkbox automatically if the system found no result of the Unique Identifier in the datatable? To be clear, I mean the value in that Row's "Sheet Unique Identifier" column was not found, and NOT that it found it but the mapped columns…
-
DATAMESH - ONE DROPDOWN COLUMN DOES NOT UPDATE
Hi, I am wondering what should I do. I have 11 specifics sheet updating the mastersheet for 5 columns. everything updates except my status column. there is no formula in that column it is a dropdown column with 4 differents choices. my datamesh is built with update immediately all fields are well set up. I have cell link…
-
Copying and Pasting Contacts From Outlook
Smartsheet should implement the ability to copy and paste contacts directly from the "To" or "Required" fields within Outlook. If the system already has the contact listed it can match them to that existing entry. However, if the contact is new it should automatically use the information copied to create an entry. When…
-
Allow for Multiple Lookup Values in DataMesh
-
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.
