Using 'OR' Function within 'COUNTIFS'

Hi, I am having trouble with a formula.

I am trying to count the number of items with a Status of "1.6 QUOTE SENT" AND "2.1 DRAFT", but I'm unable to get the formula to function. I'm having trouble correctly parsing the OR function in the formula:

=COUNTIFS({3. LIVE ORDERS Status}, OR("1.6 QUOTE SENT", "2.1 DRAFT"), {3. LIVE ORDERS Quote Sent}, DATE@row)

The formula works correctly when I am not using the OR status

=COUNTIFS({3. LIVE ORDERS Status}, "1.6 QUOTE SENT", {3. LIVE ORDERS Quote Sent}, DATE@row)

Any help would be greatly appreciated.

Thanks!

Find more posts tagged with

Accepted answers

All comments

Lucas Rayala

https://community.smartsheet.com/discussion/116326/using-or-function-within-countifs

hey Josh, I think this just needs a slight adjustment:

OR(@cell=“value 1”, @cell =“value 2”)

alternately, you could always just add the output of two COUNTIFS like this:

=COUNTIFS(<criteria 1>) + COUNTIFS(<criteria 2>)

Anjanesh Vaidya

Hi Josh S,

You can try the below formula:

=COUNTIFS({3. LIVE ORDERS Status}, "1.6 QUOTE SENT") + COUNTIFS({3. LIVE ORDERS Status}, "2.1 DRAFT", {3. LIVE ORDERS Quote Sent}, DATE@row)

I hope it will work, if not, can you please provide the screenshot for context? (Removing any sensitive information)

Thank you!

Anjanesh Vaidya

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.