extracting the email adress of a contact

Joachim Mund
Joachim Mund ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hi,

I'm not able to use the email adress of a contact in another cell.

I need this for building a specific link in another cell. e.g. https://blabla.com/#browse/profile/[email protected]

="https://blabla.com/#browse/profile/" + contact2 will not work :-(, it returns the name of the contact.

Any idea how to get this working?

Comments

  • Alejandra
    Alejandra Employee

    Hi Joachim,

    When you create a reference an individual cell —the surface value is returned. If you're goal is to return the email address, then the email address must be the surface value.

    Depending on the number or email addresses you're working with, you may want to consider either editing the Contact List properties so that it only contains only email addresses in the preferred values text box —or— you could create a new column (with only email addresses in the preferred values text box), reference the cells in this column in your formula, and hide it if needed.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!