Match Contact column list to Email Address

ker9

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.

TIA.

Genevieve P.

Hi @ker9

There currently isn't a way to extract the email address from a Contact in a Contact column. (Please submit your feedback and request to the Product team, here!)

The way I would do this is to set up a Reference Sheet with each contact listed down one column and the associated email as text in the column next to it. Then you can use this table to pull into your sheet the email address associated with that contact, either using DataMesh or cross-sheet formulas.

However, if your users are adding new rows to the sheet, you could set up a Created By system column in your sheet. This will only capture the email address of the user who created that specific row. See: Use a System Column to Automatically Add Information to a Row

Cheers,

Genevieve