Sheet Summary Formula for Counting Blank Cells

Melanie PLU
Melanie PLU ✭
in Formulas and Functions

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.

image.png


image.png


· Share on FacebookShare on Twitter

Answers

  • Genevieve P.
    Genevieve P. Employee

    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.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!