Countif Statement Not counting a criteria

S_Ko

hi there,

I have a Countif Statement running for a Dashboard on a column with multiple select. I have 3 criteria I'm isolating (image below) but the Partnership Criteria isn't counting when it should.

I've checked the formula and spelling and it's fine- here is the back end Metric Page I'm using for the "Roadmap at a Glance" view. What am I missing?

Thanks!

Nick Korna

Hi @S_Ko ,

I think you should be able to use something like this (if project type is a dropdown with multiple select):

=COUNTIFS({1. Current L&D Roadmap Range}, HAS(@cell, "partnership")),{1. Current L&D Roadmap Range 3},"Q22023/23"))

I think the reason the others are working is that they are they're alone, while your partnership is a multiple option.

If the project type is not a dropdown, then you can substitute HAS for CONTAINS.

Hope this helps; any questions etc. then just post! 😊

Nick Korna

Hi @S_Ko ,

I think you should be able to use something like this (if project type is a dropdown with multiple select):

=COUNTIFS({1. Current L&D Roadmap Range}, HAS(@cell, "partnership")),{1. Current L&D Roadmap Range 3},"Q22023/23"))

I think the reason the others are working is that they are they're alone, while your partnership is a multiple option.

If the project type is not a dropdown, then you can substitute HAS for CONTAINS.

Hope this helps; any questions etc. then just post! 😊

S_Ko

@Nick Korna I knew i was forgetting something with that formula! Thank you for the help Nick, that is exactly what I needed.

Have a great week.

Nick Korna

No problem, happy to have helped.