Contains in formula
Hello all!
I am trying to use multiple "contains" functions in a formula. I would like to search multiple columns(@row) with several strings contained in them for certain "keywords" and return a value in another column (@row) based on that search.
So, for example I want to search the first row of the first three columns and return a value in the "Presentation" column based on that search.
So my formula in the Presentation column would need to contain search of all three rows and all three "keywords" as outlines above.
Thanks!
Bob
Best Answer
-
=IF(CONTAINS("retirement", [HQY Live Webinar details]@row:RecordingDetails@row), "Retirement", IF(CONTAINS("LPFSA", [HQY Live Webinar details]@row:RecordingDetails@row), "LPFSA", IF(CONTAINS("HSA", [HQY Live Webinar details]@row:RecordingDetails@row), "HSA")))
Try this formula out. Let me know if it worked or not. If so, give me a vote up! (Keep in mind that the contains function may not be case-sensitive. "Retirement" != "retirement".
Answers
-
=IF(CONTAINS("retirement", [HQY Live Webinar details]@row:RecordingDetails@row), "Retirement", IF(CONTAINS("LPFSA", [HQY Live Webinar details]@row:RecordingDetails@row), "LPFSA", IF(CONTAINS("HSA", [HQY Live Webinar details]@row:RecordingDetails@row), "HSA")))
Try this formula out. Let me know if it worked or not. If so, give me a vote up! (Keep in mind that the contains function may not be case-sensitive. "Retirement" != "retirement".
-
Thank you Cody, that worked great! I appreciate the quick reply.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K 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
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!