Project Roll Up Percentages

Hello - New to SmartSheets so still learning the platform. I have not been able to figure out how to roll up percentages complete for each of the phases (Parent and Child tasks) of a project. Keep getting the #DIVIDE BY ZERO error. I'm lookin to roll up percentages complete on each phase of the project and up to the top-level.

Formula:

=IF(COUNT(CHILDREN()) > 0, AVG(CHILDREN()), IF(Status@row = "Not Started", "0%", IF(Status@row = "Canceled", "100%", IF(Status@row = "N/A", "100%", IF(Status@row = "In Progress", "50%", IF(Status@row = "Complete", "100%", IF(Status@row = "On Hold", "50%")))))))

Not sure what I'm missing. Thanks in advance!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!