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

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.
Answers

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.

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!
Help Article Resources
Categories
Check out the Formula Handbook template!