Counting the number of Checked Boxes
Options
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?
Regards
Best Answer
-
I figured it out...
=COUNTIFS([Phase I]1:[Phase I]20, =1) + ""
Answers
-
I figured it out...
=COUNTIFS([Phase I]1:[Phase I]20, =1) + ""
-
This Thread has a great explanation
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!