Percentage Complete

Mindy Schneider

I need a percentage of checkboxes checked for the CHILDREN rows. HELP! I am terrible at these formula's and I get errors.

John Jonassen

You won't be able to keep it in the Complete column as the Checkbox formatting is static throughout (you can't cross formats).

So in a Text/Number formula, you can populate the following formula, making sure to update the range to match what you are looking for:

=(COUNTIF(Complete2:Complete4, 1)) / COUNT(Complete2:Complete4)

I don't believe you will be able to provide a formula, in this case, that uses the CHILDREN function. I can certainly be wrong.

John Jonassen

You won't be able to keep it in the Complete column as the Checkbox formatting is static throughout (you can't cross formats).

So in a Text/Number formula, you can populate the following formula, making sure to update the range to match what you are looking for:

=(COUNTIF(Complete2:Complete4, 1)) / COUNT(Complete2:Complete4)

I don't believe you will be able to provide a formula, in this case, that uses the CHILDREN function. I can certainly be wrong.

Mindy Schneider

You are so smart! I did not realize I couldn't put it in the checkmark column. I moved it over one and got exactly what I needed.

Thanks for your help! You rock!