Did the COUNT formula change to include blank?

Gissel ✭✭
edited 06/30/22 in Formulas and Functions

I want the COUNT formula to only count checked boxes. Yesterday, this was the way the formula worked today, it counts checked and unchecked boxes.

Does anyone have any idea why this changed?


Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi all,

    It's expected that un-checked boxes should be Counted in the Summary COUNT in a Report so that you can Group by if the boxes are checked or not, then apply a Summary to both sets of Groupings:

    This way you can see in your Grouping that 7 boxes are un-checked. If you don't want to see any rows with un-checked boxes in your Report, you can use the Filter option to remove those rows from the view. See: Use Filters on Reports




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!