Syntax of an OR Statement inside a COUNTIFS

Hello,

I have a formula that is working, but I need to add an OR statement in the priority so the function detects that the if the priority is "Critical" or "Blocker" it will be counted. Here is the formula below, can somebody please help me on where to add the OR statement?

=COUNTIFS({Service Provider Name}, CONTAINS([Partner Name]@row, @cell), {Priority}, "Critical", {Status}, <>"Closed", {Status}, <>"Completed", {Status}, <>"Canceled", {Status}, <>"Duplicate", {Status}, <>"Resolved", {Issue Type}, "Bug", {GSP If Parent}, "0")

OR({Priority}, "Critical", {Priority}, "Blocker"))

Thank you!

Find more posts tagged with

Formulas

Accepted answers

All comments

Jeff Reisman

@RingJake Here you go. You just list the range once, and then use OR to give it the two choices.

=COUNTIFS({Service Provider Name}, CONTAINS([Partner Name]@row, @cell), {Priority}, OR(@cell = "Critical", @cell = "Blocker"), {Status}, <>"Closed", {Status}, <>"Completed", {Status}, <>"Canceled", {Status}, <>"Duplicate", {Status}, <>"Resolved", {Issue Type}, "Bug", {GSP If Parent}, "0")

There's a good example of this on the Help page for the OR function:

OR Function | Smartsheet Learning Center

RingJake

Terrific, thank you Jeff. Would you mind doing it for this formula too? I'm still having issues getting it just right.

=COUNTIFS({RLZ Service Provider Name}, CONTAINS([Partner Name]@row, @cell), {RLZ Priority}, "Critical", {RLZ Status}, <>"Closed", {RLZ Status}, <>"Completed", {RLZ Status}, <>"Canceled", {RLZ Status}, <>"Duplicate", {RLZ Status}, <>"Resolve", {RLZ Issue Type}, "Bug", {RLZ IfParent}, "0")

Jeff Reisman

The syntax is the same:

=COUNTIFS({RLZ Service Provider Name}, CONTAINS([Partner Name]@row, @cell), {RLZ Priority}, OR(@cell = "Critical", @cell = "Blocker"), {RLZ Status}, <>"Closed", {RLZ Status}, <>"Completed", {RLZ Status}, <>"Canceled", {RLZ Status}, <>"Duplicate", {RLZ Status}, <>"Resolve", {RLZ Issue Type}, "Bug", {RLZ IfParent}, "0")

You list the range, {RLZ Priority}, followed by a comma, and then OR statement as the criteria. The @cell tells the formula to examine every cell in the RLZ Priority column to see if any equal Critical or Blocker.

RingJake

Thank you!

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.