Lookup contact name from email address

Hi,

Users enter data into a sheet via a Form. One of the columns is a "Created By" system column. This provides me with the email address. Is there a function to lookup the name from the contact list based on the email address.

I'm aware that I could achieve something similar by have a second sheet with Names and email addresses. However, this would be duplication of data.

Answers

  • If you set your Contact List to Allow Multiple Contacts per cell and check them all off then they would all be listed at once.

    In another column, you can add a formula to Find the Created By within your Contact List.

    =IF(FIND([Created By]@row, [Contact List]@row) > 0, "Existing Contact", "New")

    Tested it on my end and it worked.

  • Hi Nick,

    I appreciate the suggestion. Unfortunately this doesn't meet my requirements. I'm attempting to minimize duplicate entry as this minimize errors.

    As I already have the email address I really should be able to lookup against the contact list. I suspect this is a feature request.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!