CountIfs with Date Range on Multi-Select Dropdown

I was hoping to be able to find the answer elsewhere but have had no luck. I was able to build the following formula from other answers but stuck on the last part of the criteria (Warning Items) being in a multi-select drop down. So the formula works but is incorrect in that it does not count cells where there is more than one option selected.

=COUNTIFS({HSE Observations Range 3 Audit Date}, <=StartDate@row, {HSE Observations Range 3 Audit Date End}, >=EndDate@row, {HSE Observations Range 2 Warning Items}, [Observation Item]@row)

Could someone help with the solution? Is this even possible? Any help would be appreciated.

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

You will need a HAS function.

HAS(@cell, [Observation Item]@row)

Sean W

@Paul Newcome you sir are awesome. When I posted the message I KNEW it would be you who would provide the solution in a straightforward manner. You have provided so many solutions that I have been able to use.

Thank you very much. 😎

All comments

Paul Newcome

You will need a HAS function.

HAS(@cell, [Observation Item]@row)

Sean W

Thank you very much. 😎

Paul Newcome

Happy to help. 👍️

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.