counting multiple select column

Hello,

I have a project plan that I'm trying to report on. I have a column for health check and a column for assigned team.

I want to see a total count of each status per team. That is the easy part and I figured that out by doing a

=COUNTIFS({HealthCheck}, "Red", {Team}, OR(@cell = "FI", @cell = "FIT"))

My issue is that it will only count if there is one team in the team column. If I have multiple teams such as FI, FIT the formula above won't count it.

How do I tell the formula to count if a value appears anywhere in a cell not exactly equal to that cell?

Find more posts tagged with

Formulas

Reports

Project Management

Accepted answers

Leibel S

Your criteria should be the HAS function.

Something like the below:

=COUNTIFS({HealthCheck}, "Red", {Team}, OR(HAS(@cell, "FI"), HAS(@cell, "FIT")))

All comments

Leibel S

Your criteria should be the HAS function.

Something like the below:

=COUNTIFS({HealthCheck}, "Red", {Team}, OR(HAS(@cell, "FI"), HAS(@cell, "FIT")))

Gil Levit

Thank you Leibel S....this is great!

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.