Sheet Summary Formula for Counting Blank Cells

Hi All, I have been playing with this formula for an hour and figured I need to get some help. My formula is below and a screenshot of the page is below that. What do I need to do to get a value other than 0 (which is not accurate)? Thanks for the assistance.



Answers

  • Hi @Melanie PLU

    I personally find it's easier to use "" in formulas instead of ISBLANK.

    Try:

    =COUNTIF(STATUS:STATUS, "")

    or

    =COUNTIF(STATUS:STATUS, @cell = "")

    or if you like ISBLANK:

    =COUNTIF(STATUS:STATUS, ISBLANK(@cell))

    Cheers,

    Genevieve

    Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!