-
Linking Columns of 2 Sheets to Feed into a 3rd
Hi There, I believe this should be fairly simple, however the steps are lost on me. In particular I am looking to take a single column from two seperate sheets and have them feed into a third. In this instance I am taking a Request Form (office supplies, multiple options from drop-down to cell) and an Inventory Form (cost…
-
Easier way to identify and transfer Premium App Assets from one user to another for System Admin
Currently there is no easy way to identify what premium app assets was created by the user who is leaving the company. (or left the company) System admin is not able to view assets created by the user for DataMesh Pivot Workapp System admin can view asset created by user but unable to transfer ownership: Data Shuttle Some…
-
Can you cell link through Bridge?
Hello, I have used DataMesh to create links. However, is it possible to use Bridge and create cell links when adding row. Instead of a write in it would be linked. If possible how would i get the link information to reference.
-
Data Mesh Auto Map columns with identical names
if I'm using 36 columns in source and target sheets I have to touch all 36 columns in both parts of the Data Mesh Column Mapping. IDEA: if the column names are identical in both places, auto fill / match columns similar to what data shuttle does.
-
Data Mesh Multi-Column Match
I think it would be beneficial to have a multi-line match option within a data mesh instead of having to setup 2 different configurations. For example, attempting to match the values in two columns to meet the criteria to proceed would help if you happen to have a few duplicates in one of your columns, then the secondary…
-
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…
-
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):…
-
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…