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.