Extract domain from Contact List Cell

ss_happychappy · 09/06/22

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.

=Chris Palmer · 09/06/22

Hello @ss_happychappy

Currently, there doesn't appear to be a way to extract contents from a contact list in Smartsheet. Because there isn't an "=Text" function like in Excel.

However, you can create a helper column as Text.

Copy and paste the Contact List Column into the Helper Column as Text.

Then apply the following formula listed here in my screenshot:

=MID([Helper Column]@row, FIND("@", [Helper Column]@row) + 1, FIND(">", [Helper Column]@row) - FIND("@", [Helper Column]@row) - 1)

Hope this helps!

ss_happychappy · 09/08/22

Thank you @Mr. Chris

This isn't ideal, however, if the functionality doesn't exist in the product this is a workaround.

I appreciate your idea :)

=Chris Palmer · 09/09/22

https://community.smartsheet.com/discussion/comment/342785#Comment_342785

Happy to help!

Extract domain from Contact List Cell

Answers

Help Article Resources

Categories