Problems with using formula to count items in drop down list

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.

Find more posts tagged with

Formulas

Accepted answers

All comments

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

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.