Don't Count if Cell is Bank

Kimberlee Adam
Kimberlee Adam ✭✭✭
edited 12/09/19 in Formulas and Functions

Hi All,

I am using a checkbox formula to count the status of a task. Is there a way to also include to not include blank cells in the count?

My formula is =IF([1 Rough Draft Writing Status]11 = "Not Started", 1, 0)

I want to drag the formula down but I also have rows that don't have anything in the status column because I'm using them as row headings.

Thank you,




  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    There are a couple of ways to do this. Which column would the blank cells be in?


    To include it in the checkbox column, you would use something along the lines of


    =IF(AND([Column Name]@row <> ""[1 Rough Draft Writing Status]11 = "Not Started"), 1, 0)


    or you can just include it in your formula used to pull the count of checked boxes.


    =COUNTIFS([Check Column]:[Check Column], 1, [Column Name]:[Column Name], @cell <> "")

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!