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?

Find more posts tagged with

Accepted answers

Matt Johnson

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

All comments

Matt Johnson

Hi @PMOGal

=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

PMOGal

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.