Unique Variable for JOIN function

Torsten Rich-Wimmer

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

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

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

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