HAS Functions Returning 0


Hi Smartsheet Users,

I am struggling with the formula HAS with multiple selection drop down values and hoping I could get some guidance here.

Here, i would like to count how many "swimming" classes I have in a week.

The expected result is 3.

In the sheet summary, I have the formula written as

=COUNTIFS(Activities:Activities, HAS(Activities:Activities, "Swimming")). This gives me a "0" value result.

If I did a formula of COUNTIF without HAS, as below, it gives me a "1" value result.

=COUNTIF(Activities:Activities, "Swimming")

What did I do wrong?




Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!