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
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
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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!