Extract domain from Contact List Cell

Options

Hi All,


I would like to extract the domain from a contact list column type to reside in a different cell.

For example smartsheet.community@helpful.com should add helpful.com to a new cell.

In excel I would use the below as an example.

=RIGHT(C4,LEN(C4)-FIND("@",C4))


Can you provide an answer for smartsheets but must work with a contact list column type..

Thank you.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!