Parse the e-mail address from a contact list entry (real time)
I realize I can convert the column from Contact List to Text/Dropdown, and reveal the "<" and ">", thus enabling the text functions, but this does not work "real time". If I use an "=" to pull the Contact into a helper column that is Text/Dropdown, I only get the name...the e-mail is not pulled over.
Ideas?
Thanks!
Answers
-
@James Fischer short of a more elegant solution, you could do this:
IF you have a manageable list of names that you don't need to constantly update, you could create a helper column that points to the contact column and says:
=IF([Recipient Email]@row="James Fischer", "james.fischer@email.com","")
I would use a series of stacked IF statements rather than nested IF statements to make this easier to read and create. You can do this in a notepad in pretty short order, like this:
=IF(email@row="User 1", user1@email.com,"") +
IF(email@row="User 2", user2@email.com,"") +
IF(email@row="User 3", user3@email.com,"") +
IF(email@row="User 4", user4@email.com,"")
This works because you can have as many formulas in a cell as you like (barring character limits) by stacking them with the plus "+" sign, and as long as each IF statement is independent from every other IF statement (meaning you won't trigger more than one at a time), then it's easier to create and parse later if you stack them rather than nesting them.
-
I've had occasions where I've generated large stacks of formulas like this using an Excel table and formulas that generate my formulas :)
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives