Using COUNTIF to find the number of Blank Spaces

cdvl
cdvl
edited 12/09/19 in Smartsheet Basics

I'm trying to count how many blank spaces there are in a given column. However, whenever I put in the below formula, it just gives me the total amount of rows in the column, but the entire column is not blank:

=COUNTIFS({CDVL Project Tasklist Range 4}, "")

I've also tried this formula, but to the same results:

=COUNTIFS({CDVL Project Tasklist Range 4}, ISBLANK(@cell))

What am I missing? 

EDIT: I've included a screenshot of the data with names blacked out. As you can see, what I have labeled at CDVL Project Tasklist Range 4 does have data in it. Some previous formulas I've used for the range include =COUNTIFS({CDVL Project Tasklist Range 4}, "Blue"), =COUNTIFS({CDVL Project Tasklist Range 4}, "Yellow"), etc. corresponding to the status color, and they've all worked. I have no clue way the BLANK formula is not working. 

Screen Shot 2019-04-25 at 2.26.42 PM.png

«1

Comments