CountIF w/ multi select

I'm trying to create a formula to count the number of rows containing a specific location where the location column is a multi select. Also, part of that formula needs to only account for that location in an "Open" status. So far I've been able to make the formula work to disregard anything that is "Complete" or "On Hold". I've been messing around with adding a CONTAINS or a FIND to the formula for gathering that specific location data, but I'm not coming up with anything that works. For example, how would I write this formula to find how many rows contain "Rural Hall" and are not under a Complete or On Hold status?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!