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 :)
Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Extract domain from Contact List Cell
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
-
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!
https://www.linkedin.com/in/zchrispalmer/
-
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 :)
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 207 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!