Using HAS with Multi-Selection Dropdown

Elliot Holder

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.

Mark Cronk

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