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?
Best Answer
-
Hi @PMOGal
I normally count another column that has a value and compare that against the status/Test Outcome column. For example, if there was a PROJECT column and a STATUS column, I would write the formula like this:
=COUNTIFS(PROJECT:PROJECT, <>"", STATUS:STATUS, "")
It reads, If the Project column is not blank and the Status (or Test Outcome) column is blank, then could the blanks in the Status column.
I hope that helps.
Matt
Answers
-
Hi @PMOGal
I normally count another column that has a value and compare that against the status/Test Outcome column. For example, if there was a PROJECT column and a STATUS column, I would write the formula like this:
=COUNTIFS(PROJECT:PROJECT, <>"", STATUS:STATUS, "")
It reads, If the Project column is not blank and the Status (or Test Outcome) column is blank, then could the blanks in the Status column.
I hope that helps.
Matt
-
Hi Matt,
Thanks for the quick reply. Using the formula you gave me:
=COUNTIFS([Area to be Tested]:[Area to be Tested], <>"", [Test Outcome]:[Test Outcome], "")
It works! Thanks.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives