# Creating a percentage from multiple tick boxes

Options

Hi All,

This may be simple but i'm struggling to get an output so hoping you can help...

I'm trying to calculate a percentage based on the number of completed tick boxes in a row/column.

I'd be ok if this initially does a count in one cell and then coverts to a percentage in another. This is the example data below:

Tags:

• ✭✭✭✭✭✭
Options

Where are you wanting to put the calculation and are you wanting to cover the entire column or just a certain number of rows?

• Options

Hi Paul

Calculation would be in the highlighted box but would cover all rows. Also looking to do a similar calc across multiple columns

• ✭✭✭✭✭✭
Options

Try something like this...

=COUNTIFS([Column Name]:[Column Name], 1) / COUNTIFS([Column Name]:[Column Name], OR(@cell = 1, @cell <> 1))

• Options

I get a Boolean Expected error when trying that...

• Options

Perfect. Thank you.

This gives me the % remaining. How would I go about calculating the % completed. Would this be easier in the same formula or in a separate cell?

• ✭✭✭✭✭✭
Options

It depends on how exactly you wanted to have it displayed.

• Options

I'm easy on the display, basically just looking to flip the result to show % complete

• ✭✭✭✭✭✭
Options

Actually the above SHOULD show the % Completed since it is counting checked boxes.

• Options

Apologies, my cell range wasn't correct. That's now covered.

One final question...

How would the formula be amended to cover data across columns rather than rows?

• Options

Thank You. I just needed to convert to a % at the end of the formula.

Really appreciate your help on this.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!