% Complete for Checkboxes Marked

GiselleF

Hello, I've looked into similar questions, but I'm struggling in how to write the formula for this. I'd like to calculate % complete of checkboxes marked for each column. Then I plan to represent the % complete in either a dashboard for reporting purposes. From what I read, it should be the =countif formula, but cannot seem to figure out. I appreciate the help!

Nick Korna

Hi @GiselleF,

You can use a formula like this:

=COUNTIF([Ann Arbour Terminal 1]:[Ann Arbour Terminal 1], 1) / COUNT(Date:Date)

For the other terminals just adjust the column name in the COUNTIF.

This will give you a decimal number which you can convert to a decimal in a column using the button in the toolbar, or you can adjust the formula slightly if you want it directly (for example, in a sheet summary) like so:

=(COUNTIF([Ann Arbour Terminal 1]:[Ann Arbour Terminal 1], 1) / COUNT(Date:Date)) * 100 + "%"

Hope this helps, but post if you have any problems/questions!