Formula to count checkboxes on a calculation sheet

Mandy Campbell
edited 10/17/22 in Formulas and Functions

I'm creating a calculation sheet to build a dashboard and am trying to count the number of checked checkboxes in a column on a different Smartsheet. The formula I'm using is:

=COUNT({Deceased Accounts Consumer Lending Completed}, 1)

It's giving me the total unchecked items instead of the total checked items. Can someone please advise what I'm doing incorrectly?

Thank you.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!