Countif and Has returning 0 from multi value cells

I have a column that has the option to have multiple values.

I created a calculation sheet so I can use the data in a dashboard, so I need to count the number of "GovDoc" and the other values but it keep returning 0

I'm using the following formula

=COUNTIF({Issues}, HAS({Issues}, "GovDoc"))

What is wrong?

Find more posts tagged with

Accepted answers

Flavio Tincani

It worked with the @cell function!

Thanks!

All comments

Lucas Rayala

Hi @Flavio Tincani, you have this set up like a summif (range, criteria range 1, criteria 1) instead of countif (criteria 1, range 1). Also, you can't put a function around your range. Try this:

=COUNTIF({Issues}, CONTAINS("GovDoc", @cell))

Good luck!

Flavio Tincani

It worked with the @cell function!

Thanks!

Lucas Rayala

Hi @Flavio Tincani glad it worked!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.