Percentage Complete of child tasks

edited 12/09/19 in Formulas and Functions


I'm trying to figure out a formula to do the following:

1.) Display percentage complete of tasks marked "complete" within a child group, at the child top level

2.) Display percentage complete of child groups in the parent row.

Note that I am not using dependencies, and am using an independent "% complete" column (I can't organize my sheet like I need to when enabled). 


See attachment for a mock-up example. Thanks in advance!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!