% complete based on count of child checkboxes.

edited 12/09/19 in Smartsheet Basics

I'm hoping someone can help me.

I have a sheet set as a grid with a list of tasks for designers to do, these are divided into 4 categories, with the tasks being indented beneath the parent category, I have a column called 'complete' that is checkboxes which the designer check once each task is compete, so like a regular gantt layout but only checkboxes instead of percentage complete against tasks.

I would like to have a % complete on each parent row in the same way as a regular gantt so that I can use this data in reports and dashboards for the benefit of the managers of those designers.

Can someone tell me the formula to use that will get a % complete based on the number of checkboxes checked please

Thank you.