How to extract the email address from column having Contact Type


Here in the "PM Name" column, I have a value which is of Contact type. I tried copying the value over to the next column, then i get the Email address Prefixed by my name(Manasa M S<>).In the next column I want to extract only the email address(eg: please share if you have formula for this problem.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!