Percentage Checkbox complete of Parent and Child Rows

bhildebrandt

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?

Genevieve P.

Hi @bhildebrandt

Are you looking for a percentage for the entire sheet, regardless of if a row is a Parent or not?

If so, you can COUNT how many boxes are checked by using COUNTIF, and then divide that by how many rows there are in the sheet by counting your Content Title column.

For example:

=COUNTIF(Done:Done, 1) / COUNT([Content Title]:[Content Title])

I would personally put this in a Sheet Summary field (if your plan has access to it) and then format this decimal into a Percent.

Let me know if this is what you were looking to do or not!

Cheers,

Genevieve

bhildebrandt

Thank you! This was exactly the solution I was looking for. Thanks for your help!

Genevieve P.

No problem! 🙂