Need help with a JOIN( Collect( Has formula

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.
Best Answers
-
It's probably the order of your syntax.
=JOIN(COLLECT({range with the values you want to list}, {range to evaluate}, criteria), delimiter)
Regards,
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Thank you! This resolved the issue!
Answers
-
It's probably the order of your syntax.
=JOIN(COLLECT({range with the values you want to list}, {range to evaluate}, criteria), delimiter)
Regards,
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Thank you! This resolved the issue!
Help Article Resources
Categories
Check out the Formula Handbook template!