Error With % Complete Child Roll-up caculation

Katye Reed
Katye Reed ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions


My team has requested that we use an average % complete of the child cells to populate the parent cell. I am struggling to get this to work. Does it matter if you are rolling up % complete that have already been used in a average formula?

For example

Task 1 % Complete is calculated by averaging % Complete for Task 1.1 and Task 1.2

Task 1.1 % Complete is calculated by the child cells 1.1.1 and 1.1.2.

Can I use this average child formula if there is only 1 child cell? Anyone know the workaround for this?

Thanks so much for the assistance!








Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!