Countif and HAS for multiselect for Quiz answers

I am using Countif and HAS to count a cell if a person has selected the correct quiz answers in a multiselect field.

=COUNTIF([Q2]@row, HAS("a", "b", "c", "e"))

This is returning 0 and I am not sure why?

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!