Percentage Checkbox complete of Parent and Child Rows

Options

I need to generate a total percentage complete of all checkboxes in an onboarding document. Checkboxes are utilized for both a parent and child rows. I've tried multiple equations but cannot determine how to set this up to get an accurate percentage of number complete. In this example "content 1" has 2 child rows while "content 4" stands alone, followed by "content 5" which has 2 child rows. What equation can I use to generate a percentage of total complete across both parent and child rows?


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!