Need formula for % Complete of 3 specific rows in sheet


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!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!