Skip to content
  • Try Smartsheet

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    Count if a cell is blank / not blank

    ✭✭✭✭
    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!

    · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Answers

    • Community Champion

      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."

      · Share on FacebookShare on Twitter
    • ✭✭✭✭

      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?

      · Share on FacebookShare on Twitter
    • ✭✭✭✭✭✭

      Hi @aecross

      Count only counts non blank values:

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

      Hope this helps!

      · Share on FacebookShare on Twitter
    • ✭✭✭
      edited 11/07/24
      Kleerfyre

      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.

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions