Counting Blank Cells
I am counting the blank cells in a column ([Test Outcome]. I have 297 rows. The choices in this column are either PASS, FAIL or a blank cell. I want to count the number of cells that are blank. Here is my formula:
=COUNTIF([Test Outcome]:[Test Outcome], ISBLANK(@cell)) - 10
In the past I read that I must use -10 as Smartsheet pads the answer. I've done this before and the correct answer has been returned.
Today, the result returned is 297. It should be 295 because two of the rows have cells with PASS in them.
Did something change in Smartsheet?