Data Mesh and Contacts
I've been having a bit of a struggle.
I have a Contacts column. If I enter an employee's email address, it auto-completes to the contact "card". However, if I use the contact column as the unique identifier between sheets for a data mesh, and the other sheet has email addresses entered via form (that do not automatically convert to a contact "card" since it was not entered manually into the sheet), then the mesh fails.
Ok. Fine. I can prevent my email from auto-completing to the contact "card" by entering the full email address, selecting all, cutting, and then pasting into the field. It's weird and inconvenient, but it works.
However, I also have a Data Shuttle that imports new employees into this sheet, and for some reason when the Data Shuttle imports or updates a row, the email address auto-completes into a contact "card", forcing me to regularly go in, look for email addresses that have switched from a straight address to a "card" and manually correct them so that my meshes with other sheets will work.
And to make all this even weirder, if I over over the straight address, it still shows as being part of the "card", so Smartsheet clearly equates the two in general with Shuttle, but not with Mesh.