Formula not working - correctly

I tried applying a formula, but the results aren’t coming out correctly. For example, the headset count is showing as 6, whereas there are actually only 3 headsets.

I suspect the issue is due to multiple items being listed in a single cell (e.g., "Headset, Keyboard"). Could someone please confirm if the formula supports multi-select values within a cell, or suggest an alternative approach?

Appreciate your help!

Find more posts tagged with

Formulas

Accepted answers

KPH

Your current COUNTIFS will only count rows where the value in Range 6 matches exactly that in the primary column.

If you use the HAS function, you can count the rows where the value of the primary column is one of the multi selected options.

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

Replace

[Primary Column}@cell

With

HAS(@cell, [Primary Column}@cell)

All comments

KPH

Your current COUNTIFS will only count rows where the value in Range 6 matches exactly that in the primary column.

If you use the HAS function, you can count the rows where the value of the primary column is one of the multi selected options.

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

Replace

[Primary Column}@cell

With

HAS(@cell, [Primary Column}@cell)

Ozu

That worked thanks @KPH.

😇

Really greatful, else was thinking to add figures manually.

KPH

Great news, thanks for letting me know.

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