Adding a Second OR to Formula

Smartsheet Community:

I have to add a second OR Statements to to the Formula but can not put my finger on what I am doing wrong.

Current Formula:

=COUNTIFS({UAT Issue Tracking Sheet Range 4}, "UAT - Phase 1", {UAT Issue Tracking Sheet Range 3}, "Highest", {UAT Issue Tracking Sheet Range 5}, OR(@cell = "New", @cell = "In Progress", {UAT Issue Tracking Sheet Range 2}, OR(@cell = "Failed", @cell = "Retest Needed")))

Thanks

Find more posts tagged with

Accepted answers

All comments

Anthony Barthelemy

I think I figured it out, Missing Parenthesis

New Formula:

=COUNTIFS({UAT Issue Tracking Sheet Range 4}, "UAT - Phase 1", {UAT Issue Tracking Sheet Range 3}, "Highest", {UAT Issue Tracking Sheet Range 5}, OR(@cell = "New", @cell = "In Progress"), {UAT Issue Tracking Sheet Range 2}, OR(@cell = "Failed", @cell = "Retest Needed"))

Genevieve P.

Hi Ray,

Looks like you got it! The OR function needs to have a closing parenthesis after the criteria so it knows when to go back into the COUNTIFS function instead of the OR.

Thanks for sharing your final formula!

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.