COUNTIF and HAS functions not working on multiselect columns

jennistasiak

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?

Nic Larsen

I see an extra/closing ) after your range that you don't need.

jennistasiak

Thanks, @Nic Larsen - I guess I accidentally added an extra one every time because it's fixed now!