I have a client that wants to add a "Percent Tasks Complete" column to the tasks sheet. For example, the summary task "Safety Tests" contains:
SafetyTest1 is 100% complete (in the "% Work Complete" column). The other two safety tests are 90% complete. The percentage of tasks complete column should show "33.3%" in the "Safety Tests" summary task under the "Percent Tasks Complete" column because 1 out of the 3 tasks under that summary task are 100% complete, and 1 out of 3 = 33.33%.
There does not seem to be any easy way of adding a column like this. I tried creating a custom field, and I can get it to say "1" for each complete task and "0" for each incomplete task, which I thought could be a step along the way.
How do I do the rollup to summary tasks?