This formula is working for other number ranges but not this one

Hello,

Trying to do a count and this formula is working for all other number ranges, except for this one. Any ideas? Formula is this: =COUNTIFS([Risk Issue Factor Priority]:[Risk Issue Factor Priority], ">0", [Risk Issue Factor Priority]:[Risk Issue Factor Priority], "<7", Status:Status, "<>Complete", Status:Status, "<>Closed")

Find more posts tagged with

Formulas

Accepted answers

All comments

jmyzk_cloudsmart_jp

Hi @Ali EGordon

What is your "this one"?

At first, I thought your ">0" and "<7" were wrong, but they work,

In my demo sheet, I came up with the following formula that copes with the Status = blank case.

=COUNTIFS(
 [Risk Issue Factor Priority]:[Risk Issue Factor Priority], 
   AND(@cell > 0, @cell < 7), 
 Status:Status, 
   OR(ISBLANK(@cell), AND(@cell <> "Complete", @cell <> "Closed"))
)

https://app.smartsheet.com/b/publish?EQBCT=16f78281d20b42eb8312fdb6c3aa9bcd

Another possibility is that your number range contains a text value.

https://app.smartsheet.com/b/publish?EQBCT=97964f1760d3492a86240150275064d9

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.