Count if a cell is blank / not blank

Options
aecross
aecross ✭✭
edited 06/07/23 in Formulas and Functions

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!

Answers

  • Kleerfyre
    Kleerfyre ✭✭✭✭✭✭
    Options

    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.

    Jonathan Sanders, CSM

    "Change is always scary because it is unknown, but facing the unknown is what makes us stronger."

  • aecross
    aecross ✭✭
    Options

    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
    ker9 ✭✭✭✭✭✭
    Options

    Hi @aecross

    Count only counts non blank values:

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

    Hope this helps!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!