Need help with a JOIN( Collect( Has formula

Marilu M

Hello,

I am trying to reference sheet A in sheet B. I am trying to get a list of all the organizations in sheet A that have listed they will do work in the1st District. The District Column is a multi-select option, so organizations have listed several districts. I want the list of all the organizations doing work in the 1st district to appear in a single cell. I tried this formula, but it comes up as Incorrect Argument set.

=JOIN(COLLECT({FY22 NAI Funding Application Range 7}, HAS(@cell, "1st")), {FY22 NAI Funding Application Range 4}, ",")

Any help is highly appreciated.

Jeff Reisman

It's probably the order of your syntax.

=JOIN(COLLECT({range with the values you want to list}, {range to evaluate}, criteria), delimiter)

Marilu M

Thank you! This resolved the issue!

Jeff Reisman

It's probably the order of your syntax.

=JOIN(COLLECT({range with the values you want to list}, {range to evaluate}, criteria), delimiter)

Marilu M

Thank you! This resolved the issue!