Project Roll Up Percentages

Greg_2025

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!

Paul Newcome

Your formula is outputting text values on the child rows. Just output numbers (percent is as a part of 1 so 50% = 0.50, 25% = 0.25, etc.) and then format the column as percentages.

Paul Newcome

Your formula is outputting text values on the child rows. Just output numbers (percent is as a part of 1 so 50% = 0.50, 25% = 0.25, etc.) and then format the column as percentages.

Greg_2025

Thanks, Paul. Appreciate the quick response and all set.

Paul Newcome

Happy to help. 👍️