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

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…

Find more posts tagged with

Reports

metrics

sheet reference

Accepted answers

All comments

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…

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.