#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

# Checkbox % formula

Options
edited 12/09/19

I have a checkbox column, no children, and I want to calculate what percentage of the checkboxes are checked for a specific range.  Is there a formula that could do that?

Thank you!

• Options

Yes this formula will count how many are checked: =COUNTIF([1]1:[1]5, true)

Then you'd just have to do a separate count for all cells in the range, and divide the two numbers.

• edited 12/15/16
Options

I figured out how to count the checkboxes, but I couldn't use that number in another formula.  Am I missing something?

• Options

Once you get the result, you'd set up another formula to count all cells within a range. Your third cell would compute those two number. Is that what you tried? Like this attached.

• Options

Thank you!  I don't know what I was doing wrong before, but it's working now.

This discussion has been closed.