Formula to count of items in a multi dropdown list

Genevieve P.

Hi @S. Medlin

If you're looking in a multi-select column, I would actually recommend using HAS instead of CONTAINS. HAS is built specifically for single values selected with other values in one cell:

=COUNTIFS({Impacted Workgroups}, HAS(@cell, [email protected]))

Then if you have other criteria to filter by, you just need to add the new range, comma, then criteria:

=COUNTIFS({Impacted Workgroups}, HAS(@cell, [email protected]), {Priority Column}, "Priority 1")

If I've misunderstood what you're looking to do, it would be helpful to see a screen capture of the source sheet, where the data comes from.

Cheers,

Genevieve

OFNS BCPS

Hi I am hoping you can help me out here. I am trying to create a pie chart on a dashboard to display the proportion of technology types that are being serviced. This is a drop-down list with 5 different values. I read it is easiest to count the values individually in the Sheet Summary and then use that to create the chart on the dashboard. If you have a better idea, please let me know.

=(COUNTFS([Technology Type]:[Technology Type], CONTAINS("Computer", @cell))

I am using the above formula but it is coming back as "UNPARSEABLE" Can anyone help? Thanks! @Genevieve P.

Genevieve P.

Hi @OFNS BCPS

I've responded directly on your other post, here:

https://community.smartsheet.com/discussion/96601/problems-with-using-formula-to-count-items-in-drop-down-list

As a re-cap, try this:

=COUNTIFS([Technology Type]:[Technology Type], HAS(@cell, "Computer"))

Cheers,

Genevieve

OFNS BCPS

Thank you so much for your help!