CountIf for check boxes

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

Good afternoon, 

 

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

 

Thanks

 

 

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)

     

«1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!