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.
What did I do wrong?
Help Article Resources
Check out the Formula Handbook template!