Help w/ Countifs for multi-select drop down field

Alex Hackford

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!

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.