Add the emails as hyperlinks - get it recognized by contact list

Hi All,

is this function supported: =Alias@row&"@email.com" - in the 'Alias' column I have logins & I would like to add to this aliases in another column also the domain: "@email.com" so they get recognized by the contact list.

Thanks - Viktor

Tags:

Best Answer

  • Robert Charles
    Robert Charles ✭✭✭
    edited 02/10/21 Answer ✓

    This may take a few iterations: This is not the full answer because breaks easy.

    Column formula: =IF(NOT(ISBLANK(Alias@row)), Alias@row+"@"+Domain@row)

    Below is Row 3 being assigned a contact. The dropdown includes all calculated contacts and the ones in the contact list.

    And the contact list:


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!