I am trying to create a formula - multi selection dropdown menu and between two dates.

I am trying to create a formula to count how many "A" in in the dropdown menu column which you can select multiply answers. I also need this formula to look at the 1st quarter only of 2025. Any information will be appreciated.

=COUNTIFS([THREAD]:[THREAD], HAS("A", AND([Date Submitted]:[Date Submitted], >=DATE(2025, 1, 1), AND([Date Submitted]:[Date Submitted], <=DATE(2025, 3, 31)))))

Find more posts tagged with

Multi-Select Dropdown

Accepted answers

Terry Naegelen

I ended up using the AI system within @SS, and it generated the correct formula!

=COUNTIFS([Date Submitted]:[Date Submitted], >=DATE(2025, 1, 1), [Date Submitted]:[Date Submitted], <=DATE(2025, 3, 31), [THREAD Value]:[THREAD Value], HAS(@cell, "A"))

All comments

Kelly Moore

Hey @Terry Naegelen

Try this:

=COUNTIFS([THREAD]:[THREAD], HAS(@cell,"A"), [Date Submitted]:[Date Submitted], AND(IFERROR(YEAR(@cell),0)=2025, IFERROR(MONTH(@cell),0)⇐3))

Does this work for you?
Kelly

Terry Naegelen

Thanks, Kelly. It did not work for me.

Terry Naegelen

I ended up using the AI system within @SS, and it generated the correct formula!

=COUNTIFS([Date Submitted]:[Date Submitted], >=DATE(2025, 1, 1), [Date Submitted]:[Date Submitted], <=DATE(2025, 3, 31), [THREAD Value]:[THREAD Value], HAS(@cell, "A"))

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.