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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!