Counting the number of Checked Boxes


I have a column name Phase I and I want to count all the checked boxes from row 1 through row 20.  I am using the following formula:

=COUNTIFS([Phase I]1:[Phase I]20, =1) What I get is #Boolean Expected?

Any Suggestions?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!