Creating a metrics report - Sheet reference not working/displaying criterion

gwilkinson

I have a metrics report I am building out for a dashboard, and have a column with a few drop-down options. I am trying to count how many of each category, and it decided it doesn't want to work. I am using the following, and this worked for the status column IE: Showing Started, Not Started, Resolved. But this column with a few more items simply will not count.

Is something not right here, or is Smartsheet being stubborn with this column?

=COUNTIF({Notice Type 1}, Category1)

=COUNTIF({Notice Type 1}, Category2)

And So on…

Paul Newcome

Try this:

=COUNTIF({Notice Type 1}, HAS(@cell, Category1))

gwilkinson

I understood your example and went AHA when I read it… But it didn't work. What DID work was the following… Which seems kind of a dirty way about it, but I'll take it…

=COUNTIF({Notice Type 1}, "Overcrowded cage(s)")

Seems to work great on all of these…