How to convert the names to related emails
I have data in the main file and there are mixture of PM names and emails .I want to extract few of them from the list but the problem is since they are not same I mean mixture of email and Name not able to build a precise formula. Help in converting them to proper fromat before extraction.
Answers
-
Are you able to share an example of what the column contains so we can understand the problem? If this is real people's data, can you use some fake names and emails and make a list that is similar? Then another list showing what you want to achieve.
You might be able to utilize the FIND function to look for @ signs or something along those lines.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 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!