Looking to COUNTIF with an OR function for a cross sheet formula.

Having trouble with the last part - the Status column is a dropdown with 5 options. I want it to count if it meets all of the entity, type of request and then if the Status is Ready for Approval OR On Hold. The problem with my formula is after the OR part. Anyone have some advice?

=COUNTIFS({Entity}, [A]109, {Type of Request}, Backfill, {Review}, "0", {Status}, OR(@cell=“Ready for Approval”, @cell=“On Hold”)

Find more posts tagged with

Formulas

Accepted answers

All comments

Mark.poole

I am not sure if its a copy and paste issue or not. How ever I do notice the formula you provided has a sentax issue. Missing the ) to close off the countif.

=COUNTIFS({Entity}, [A]109, {Type of Request}, Backfill, {Review}, "0", {Status}, OR(@cell=“Ready for Approval”, @cell=“On Hold”))

Melitta

@Mark.poole Thanks. Unfortunately, that's not the issue.

Nic Larsen

Try:

=COUNTIFS({Entity}, [A]109, {Type of Request}, "Backfill", {Review}, 0, {Status}, OR(@cell =“Ready for Approval”, @cell =“On Hold”))

Is A109 a cell reference or an entity #? If its not a specific cell reference, I'd wrap that in quotes as well.

=COUNTIFS({Entity}, "[A]109", {Type of Request}, "Backfill", {Review}, 0, {Status}, OR(@cell =“Ready for Approval”, @cell =“On Hold”))

Mark.poole

https://community.smartsheet.com/discussion/comment/439034#Comment_439034

I usually catch the issues with text not being wrapped in "" and numbers being wrapped in "".

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.