% Complete Report using boxes specific to create report

With a % Complete column, we'll use nested IF statements to assign your values to the checked rows. Since you have a hierarchy, we'll use a CHILDREN function and a DESCENDENTS function in here too, and through in AVG/COLLECT for good measure. Make sure your % Complete column is formatted for %:

I am assuming you want this broken down by the overall Phase (Phase 1, Phase 2, etc,) and also by individual Phases (Sales, Network, License, etc.)?

On the child rows for your the smallest Phases (Sales, etc), in the % Complete column, use:

=IF([Board Report]@row, IF(Status@row = "Complete", 1, IF(Status@row = "Not Started", 0, ""), "")

In English, if the board report column is checked, consider if Status column equals Complete, and if it does, set this value to 1; otherwise, consider if Status column equals Not Started, and if it does, set this value to 0; if it's any other value, or if Board Report column is unchecked, leave the cell blank.

On your Phase parent rows for Phase 1 Sales, etc, in the % Complete column, use:

=AVG(COLLECT(CHILDREN([% Complete]@row), [Board Report]:[Board Report], 1))

In English, give me the average % Complete of the children of this subphase, where Board Report is checked.

On the over Phase row, in the % complete column, use:

=AVG(COLLECT(DESCENDENTS([% Complete]@row), [Board Report]:[Board Report], 1))

In English, give me the average % Complete of all the descendants of this Phase, where Board Report is checked.