Count if a cell is blank / not blank

I'm trying to create a formula to help show when tasks are past due.

Basically, I want to count cells where Range 32 is NOT blank (or is a date) and where Range 31 is blank (or is not a date, as it has not been filled in yet).

I don't think this format is correct at all, but I'm struggling on where to go next.

=COUNTIFS(NOT(ISBLANK({Range 32})), AND(ISBLANK({Range 31}))

I appreciate any and all help!

Find more posts tagged with

Accepted answers

All comments

Kleerfyre

Is this formula being used on a different sheet? Are you wanting these to add up? If so, this formula might work:

=COUNTIF({Range 32}, <>" ") + COUNTIF({Range 31}, =" ")

There is a blank space between the quote marks.

aecross

Hi there! I used this formula but am only receiving "0" as an output, when I know that is incorrect. I tried this with a few different ranges and continued to receive 0. Any ideas on how to fix that?

ker9

Hi @aecross

Count only counts non blank values:

Count({Range 32}) + COUNTIF({Range 31}, =" ")

Hope this helps!

Chris_Lloyd

https://community.smartsheet.com/discussion/comment/379265#Comment_379265

This only worked without the blank spaces between "" for me.

Edit to add a Thank You to Kleefrye. Wouldn't have gotten that close w/o this suggestion.

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.