Using the COUNTIFS to determine quantity for feedback

Jason Fruhschien

Hello,

I am trying to determine a count of a Theme and Sub-Theme but do not seem to be able to since the Sub-Theme column is a multi-select dropdown. Any advice on how to do this?

Currently, I am using the following formula: =COUNTIFS({Range 1}, "Theme Name", {Range 2}, "Sub-Theme Name"))

The only time the formula is calculating the correct # is when there is only 1 selection for the sub-theme. When there are multiple, it does not calculate anything.

Any advice when calculating 2 ranges, with one being a multi-select drop down?

Kelly Moore

Hey @Jason Fruhschien

When searching multiselect columns, try the HAS or CONTAINS functions

=COUNTIFS({Range 1}, "Theme Name", {Range 2}, HAS(@cell, "Sub-Theme Name"))

Will this work for you?

Kelly

This reference may offer insight

https://help.smartsheet.com/function/has

Kelly Moore

Hey @Jason Fruhschien

When searching multiselect columns, try the HAS or CONTAINS functions

=COUNTIFS({Range 1}, "Theme Name", {Range 2}, HAS(@cell, "Sub-Theme Name"))

Will this work for you?

Kelly

This reference may offer insight

https://help.smartsheet.com/function/has

Jason Fruhschien

Hi @Kelly Moore Thank you for that information! That worked perfectly and is counting now correctly! Appreciate your insight and help! Just for reference for anyone else, I did also try using CONTAINS in the formula originally but that did not work. The HAS addition is what did the trick. Thank you Kelly!