Need help with a JOIN( Collect( Has formula



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.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!