Formula for %Complete Column (or progress bar) for 5+ Checkboxes columns

Emma1516156165

Hi!

I am looking for a formula to either give a percentage complete or similiar from a number of checkboxes.

I have tried;

=COUNTIFS([T1]@row1]:[T7]@row1],=1) - results in UNPARSEABLE

=COUNTIF([T1]2:[T7]2, "True") / COUNT([T1]2:[T7]2) = 0

=COUNTIF([T1]2:[T7]2) / COUNT([T1]2:[T7]2) = incorrect argument set

Nick Korna

Hi @Emma1516156165,

The formula to use here for counting the checkboxes is:

=COUNTIF([T1]@row:[T7]@row, 1)

If each stage is equally weighted, then you can add a divisor and make your column a percentage with this formula:

=COUNTIF([T1]@row:[T7]@row, 1)/7

Example:

Hope this helps - if you've any questions then just ask! 😊