I am trying to create a Data Mesh that updates the contacts in a column, but when I run the data mesh, it says there are no affected cells, which I know is incorrect. Just wondering if it works with Contact List column types?
Hi @Amy Meekings
Yes, DataMesh can copy contents from one Contact column to another Contact column in a different sheet, matching the rows based on the Lookup Value.
It sounds like perhaps your configuration is filtering out the rows to map. Would you be able to post a screen capture of your configuration and the two sheets, but block out sensitive data?
I am having the exact same issue. I have a lookup table (the source) where I have everyone's email address and the next column is a contact list.
The target sheet has a submitted by column (which is set to created by) and an employee name (which is a contact list). I am using a form and rather than having someone select who they are, I want to use the submitted by and then store the contact list from the source because I don't want reports to be using the email address of submitted by. I don't have any filters on and it just won't update the contact list name in the target sheet.
Also, once I changed the target employee name from a contact list and just coded a vlookup the old fashioned way, that calculates fine.
DataShuttle should be able to match an email address across two sheets and bring in a Contact Value. Could there be an issue with the workflow configuration? Are other columns updating, just not the Contact column?
That said, if you're able to do this with a VLOOKUP or INDEX(MATCH formula it sounds like that would be a good way to proceed.
Hi, Can dynamic views be accessed on smartphones/mobile devices? I don't see this option on the app.
I am trying to create a library of all the smartsheets we have using Bridge and automatically update this list as more sheets are added. Basically it will list sheet name, id, owner and link I have difficulty to figure out how to add them one by one. it only adds one row on the sheet. I feel like there may be have to be…
I have finally gotten my first bridge to Smartsheet workflow working. My workflow copies project plan baseline dates to an original baseline field the first time a baseline is set, and then will not set it again. This works when I manually setup a trigger in bridge for a specific project plan sheet. However, I have 75…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.