Need formula for % Complete of 3 specific rows in sheet

MisfitStormer

Hi -

My project has 3 phases in it and I would like to be able to show not only the % Complete of each phase but for the project overall. I have each phase working by enabling the dependencies and it is already calculating for those but I cannot get a formula to work to calculate the over all % Complete for Row 1.

Does anyone know the right formula to use? Thanks in advance!

Paul Newcome

If you are using dependencies, you should be able to just indent all of the phase rows so that they are children of the top row.

Paul Newcome

If you are using dependencies, you should be able to just indent all of the phase rows so that they are children of the top row.

MisfitStormer

THANK YOU Paul!!! I don't know what I didn't think of that before! Greatly appreciate your help!!

Paul Newcome

Happy to help. 👍️