Problems with using formula to count items in drop down list

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.

Jamie Jae

Hello,

You are missing an "I" in your formula, if you change it to the following, this should work:

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

Genevieve P.

Hi @OFNS BCPS

Thanks for the tag! I agree with @Jamie Jae .

Additionally, if you're looking in a multi-select column, you may want to use the HAS function instead. This is built specifically for multi-select type of columns and will check if the cell has that specific value along with others:

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

See: HAS Function and COUNTIFS Function

Cheers,

Genevieve