CountIf for check boxes

BESP10 ✭✭✭✭✭✭
edited 02/13/23 in Formulas and Functions

Good afternoon, 


Can you do a Countif formula for a column that has that you can count how many rows have the check box?





Best Answer

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Answer ✓

    Yes, this is totally possible. The following formula will count all checked checkboxes. Just replace the checkbox column name in the formula with the name of yours.

    =Countifs([Checkbox Column Name]:[Checkbox Column Name], =1)




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!