Datamesh for multiple contacts
I have a reference sheet where I list the way various my sales team's names appear in different reports (i.e. first initial last name on Report 1, first name last name on Report 2, etc.).
Each of these is matched to a Contact column which holds their Smartsheet contact.
Recently, a new report format has been added that has teams instead of individual sales people. So, for example, I now have a team for Joe and Mary. I updated my Contact column to allow multiple entries on my lookup sheet.
Here's the problem- when this is meshed with the destination sheet (also a Contact column with multi-select enabled), I just get text strings with name and email, name and email. This eliminates the ability to use the Current User filter option on sheets and in reports.
Is there any way to mesh a multi-contact source to a multi-contact target with Datamesh so that I can give both team members visibility using Current User?
Please note- I tested it on the target sheet manually (no mesh)- both contacts can see the row under Current User, so I've verified that part will work.
Thanks for the help.