Contact Formula from Latest Comment Column
Hello all - I'm looking for some formula help. Without getting to deep, I'm looking to develop a formula that can extract the emails from Latest Comment, regardless of their position in the comment, if/when they are added in the latest comment.
I currently can move (1) email but not multiple ones. I then put it in a helper column to then run a report off by current user for our ticket system.
With some community searches, Here is my current formula:
=IFERROR(REPLACE(RIGHT(LEFT([Latest Comment]@row, FIND("@", [Latest Comment]@row, 1) - 1), LEN(LEFT([Latest Comment]@row, FIND("@", [Latest Comment]@row, 1) - 1)) - FIND("!", SUBSTITUTE(LEFT([Latest Comment]@row, FIND("@", [Latest Comment]@row, 1) - 1), " ", "!", LEN(LEFT([Latest Comment]@row, FIND("@", [Latest Comment]@row, 1) - 1)) - LEN(SUBSTITUTE(LEFT([Latest Comment]@row, FIND("@", [Latest Comment]@row, 1) - 1), " ", ""))), 1)) + LEFT(MID([Latest Comment]@row, FIND("@", [Latest Comment]@row, 1), 256), FIND(" ", MID([Latest Comment]@row, FIND("@", [Latest Comment]@row, 1), 256), 1)), 1, 1, ""), "")
Any help with this would be great. Thank you!
Michael
Michael Halvey
"Strive for Progress, not Perfection."
Answers
-
It is not currently possible to use a formula to populate multiple usable contacts within a single cell.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@Paul Newcome - Sounds good. Thank you as always for your wisdom and wealth of knowledge.
Michael Halvey
"Strive for Progress, not Perfection."
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!