Checkbox formula with percentage

Tara Knox

Smartsheet guru's--

I'm still learning how to use all of Smartsheet's assets. I am trying to show a percentage for checked boxes. Can someone help me with the formula part?

Thank you!

David Tutwiler

That should give you the number of all checkboxes. Now you need to divide that by the number of checkboxes that have been checked to get the percentage. It will look like:

=COUNTIF([Completed?]1:[Completed?]4, 1) / COUNT([Completed?]1:[Completed?]4)

David Tutwiler

That should give you the number of all checkboxes. Now you need to divide that by the number of checkboxes that have been checked to get the percentage. It will look like:

=COUNTIF([Completed?]1:[Completed?]4, 1) / COUNT([Completed?]1:[Completed?]4)

Tara Knox

David thank you for responding!

Now how would I get a percentage to show of the boxes checked?

Tara Knox

Also, if not all boxes are checked it says this:

and I am looking to display a percentage, whether it be 0% or 100%

David Tutwiler

I think the problem you're running into is that you're trying to show the formula for a percentage in a column meant for check boxes. It is saying "Boolean Expected" because it expects either True or False (Checked or Not Checked). If you take the formula I put in my previous response in a text/number column then it will work

David Tutwiler

Or better yet, you could add a Summary field by selecting the Summary on the right panel and creating a new field that uses the same formula.

Tara Knox

It worked once I moved it to a different column! now how can I change it to display as a percentage?

John Jonassen

@David Tutwiler did all the heavy lifting on this, but you can easily get the percentage format by using the % at the top of your sheet but under the sheet name, toward the right side.

Tara Knox

I just saw that @John Jonassen! Thank you and @David Tutwiler for all the help!

David Tutwiler

Exactly. Thanks @John Jonassen

David Tutwiler

No problem. Glad it's working Tara.