Unique Variable for JOIN function

Hi All,

I am attempting to use CONTAINS in tandem with JOIN(COLLECT()) to populate courses employees must take based on the care-area in which they work. In the below example, the contents of 14A are also being pulled into 4A since they both contain "4A". Is there a way to search for 4A as an absolute? (Unfortunately, I am unable to change the names of the Care-Areas as they are populated externally; so, something like *4A is out of the question.)

Screen Shot 2021-05-25 at 1.29.38 PM.png

My code is:

=JOIN(COLLECT([eLearning Assignment]:[eLearning Assignment], [Care-Area]:[Care-Area], CONTAINS([Assignment Index]@row, @cell)))

My original Question is here: https://community.smartsheet.com/discussion/79694/using-index-function-with-multi-select-columns#latest

Find more posts tagged with

Formulas

Accepted answers

Mark Cronk

Try:

=JOIN(COLLECT([eLearning Assignment]:[eLearning Assignment], [Care-Area]:[Care-Area], HAS(@cell, [Assignment Index]@row)))

HAS looks for an exact match in a multiselect column.

Mark

All comments

Mark Cronk

Try:

=JOIN(COLLECT([eLearning Assignment]:[eLearning Assignment], [Care-Area]:[Care-Area], HAS(@cell, [Assignment Index]@row)))

HAS looks for an exact match in a multiselect column.

Mark

Torsten Rich-Wimmer

Yes! That is perfect. Thank you, Mark! Community really needs the ability to send coffee to people as thanks!

Mark Cronk

:) great idea. Happy to help for a simple Vote Up or Insightful tag. Glad you found a solution. Thank you for contributing to the Community.

Mark

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.