Countif and Has returning 0 from multi value cells

Flavio Tincani
Flavio Tincani ✭✭✭
edited 03/19/23 in Formulas and Functions

I have a column that has the option to have multiple values.

I created a calculation sheet so I can use the data in a dashboard, so I need to count the number of "GovDoc" and the other values but it keep returning 0

I'm using the following formula

=COUNTIF({Issues}, HAS({Issues}, "GovDoc"))

What is wrong?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!