Checkbox formula with percentage

Tara Knox · 10/22/20

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 · 10/22/20

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 · 10/22/20

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 · 10/22/20

David thank you for responding!

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

Tara Knox · 10/22/20

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 · 10/22/20

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 · 10/22/20

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 · 10/22/20

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

John Jonassen · 10/22/20

@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 · 10/22/20

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

David Tutwiler · 10/22/20

Exactly. Thanks @John Jonassen

David Tutwiler · 10/22/20

No problem. Glad it's working Tara.

Checkbox formula with percentage

Best Answer

Answers

Help Article Resources

Categories