Can HAS formula be combined with AND?

I have multi select column - so I was able to do HAS to count all criteria in the column, but I also would like to count if there is a combination of two items in column as well -

So let's say, I have a column called Course Type - i have four possible types - Self-Paced, Class, Video, On-Demand. So some courses have two choices - Self-Paced and Class. So I would like to count those combinations -

What I did was

=COUNTIF({Course Type}, HAS(AND(@cell, "Self-Paced"),(@cell,"Class"))

it does not work since it came out as #UNPARSEABLE

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!