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

Find more posts tagged with

Accepted answers

Cody Holmes

=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".

All comments

Cody Holmes

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".

Bob Kernan

Thank you Cody, that worked great! I appreciate the quick reply.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.