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
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 202 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 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!