Lookup contact name from email address

Options
Michael Halhead
Michael Halhead ✭✭
in Formulas and Functions

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.

Tags:
· Share on FacebookShare on Twitter

Answers

  • Nick Brisson
    Nick Brisson ✭✭✭
    Options

    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.

    · Share on FacebookShare on Twitter
  • Michael Halhead
    Michael Halhead ✭✭
    Options

    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.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!