Countif with multi values and variations

I have countifs statement but then need to account for multi-value dropdown list and wonder the best way to capture the values. So counting projects status of in project - with a business value of 6 options (multi-value).

So Business Value column has multi-value options from a drowndown. I really only care about the total number of projects that have business value of cost savings and not the variations that may be in that column given that it's a multi-value.

I have the countifs portion - just not multi values.

Find more posts tagged with

Formulas

Countif

Accepted answers

All comments

AKnight

Hi @shawn liston !

I would check out the HAS function. It will allow you to look through the multiselect column for when "cost savings" is selected.

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.