Using HAS with Multi-Selection Dropdown
Hi, I have a multi-selection dropdown with region selections. Next to that column I have the regions. For reporting purposes I need the column for each region to say "Yes" or "No" based on the items selected in the multi-select dropdown. I've created this formula with a variation for each column:
=IF(HAS("Central", [Regional Participation]@row), "Yes", "No")
As you can see in the screen shot, I only get a "Yes" response when that selection is the only one selected in the drop down. How can I get it to look for each on? I also tried the CONTAINS formula, but that won't work since we have multiple "North", "South", "Central", etc.
Answers
-
Hi @DaveyJones13 ,
Try: =IF(HAS([Regional Participation]@row, "Central"), "Yes", "No")
You had the syntax reversed. HAS looks for an exact match. "Central" won't return true for "North Central" or "South Central".
Help?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!