COUNTIF and HAS functions not working on multiselect columns


Hi! I am having an issue with using the COUNTIF and HAS functions together to count all instances in a select all that applies column. I'm specifically using this on a metric sheet to add it on my dashboard.

Any ideas on what I'm doing wrong?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!