Help w/ Countifs for multi-select drop down field

Hi,

I am trying to use the following countif on a RAID log where the 'impacted validation report' (RAID Log - Template Range 1) is a multi-select drop down field. I cannot get the formula to return anything but 0 when I know there are outstanding issues in each different status.

This is the raid log and formula. Each column references a different status and RAID Log - Template Range 2 is the status column. All the lines in yellow should be returning values other than 0 based on manual counts in the RAID log.

The formula I'm using is:

=COUNTIFS({RAID Log - Template Range 1}, CONTAINS([Item Type]@row , @cell ), {RAID Log - Template Range 2}, "In Process")

Any help would be greatly appreciated!

Find more posts tagged with

Formulas

Countif

Accepted answers

All comments

Andoni

Hello! Could you try the below? If I'm understanding correctly, I have a similar use case set up that tracks, not multi-dropdown, but a contact column where multiple values are allowed, so the logic should hopefully be the same. Following my setup yours should look something like -

=COUNTIFS({RAID Log - Template Range 1}, HAS(@cell, [Item Type]@row), {RAID Log - Template Range 2}, "In Process")

NicoLHC

@Alex Hackford

Your formula returns 0 because COUNTIFS can’t check inside multi-select fields directly. Try this short fix:

Replace CONTAINS with HAS:

=COUNTIFS({RAID Log - Template Range 1}, HAS(@cell , [Item Type]@row ), {RAID Log - Template Range 2}, "In Process")

Why?

HAS works with multi-selects to see if your Item Type exists in that cell.
CONTAINS doesn’t parse multi-select dropdowns in COUNTIFS.

Give that a go and let me know if it starts returning the counts you expect.

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.