Multiselect values being treated as one group instead of separate values.

sabrinamborrego

I have a join(collect) formula set up to look for a matching value and to return all of the test names that the restaurant (matching value) is running. That test name can have multiple restaurants selected in a multi-select dropdown column.

When I have one restaurant selected, this formula works great. When there is more than one restaurant selected, the formula doesn't return anything. I know this is due to the way the values are being treated but is there a way around this?

Paul Newcome

Try this:

=JOIN(COLLECT({2024 Test Markets Range 1}, {2024 Test Markets Range 3}, HAS(@cell, [Restaurant Number]1)), ", ")

Paul Newcome

You will need to incorporate the HAS function to get it to evaluate the multi-select options as individual selections.

sabrinamborrego

This is the formula, do you have a suggestion on where?

=JOIN(COLLECT({2024 Test Markets Range 1}, {2024 Test Markets Range 3}, {2024 Test Markets Range 3} = [Restaurant Number]1), ", ")

I was thinking doing it this way but I get an error. This makes the most sense, to me, out of all the ways I've tried:

=JOIN(COLLECT({2024 Test Markets Range 1}, {2024 Test Markets Range 3}, =HAS({2024 Test Markets Range 3} = [Restaurant Number]1, [Restaurant Number]1), ", "))

Paul Newcome

Try this:

=JOIN(COLLECT({2024 Test Markets Range 1}, {2024 Test Markets Range 3}, HAS(@cell, [Restaurant Number]1)), ", ")

sabrinamborrego

Saved me a lot of time, thank you Paul!

Paul Newcome

Happy to help. 👍️