Countif Formula not reporting Accurate number

Hello,

I'm trying to report a metric on a dashboard and am using the following formula:

=COUNTIF({Master Project Tracking Range 1}, ISBLANK(@cell) and the total is 29, however when I filter the grid the data is pulled from there are only 19 blank cells.

I've also tried =COUNTIF({Master Project Tracking Range 1}, "") and get 29. 🤔

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Because it is counting the 10 blank rows at the bottom of the sheet. Either subtracting 10 form the COUNTIF or switching to a COUNTIFS and including a range/criteria set for a column that is not blank should solve the problem.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!