Match Contact column list to Email Address
Has anyone found a practical solution to match a Contact column to an email address?
It can't be done in DataMesh and while I've done some searching on the board and help files, I haven't found a method to do this that doesn't require a lot of manual intervention.
The problem with Smartsheet Contacts is that people can change their name to be anything they want. Email addresses, however, are static, which allows matching across systems.
We are using Dynamic View to add new data to a sheet, which allows accurately capturing the contact information much better than a form. We want to DataMesh by email address to insert other related information.
Help Article Resources
Check out the Formula Handbook template!