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
-
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.
Answers
-
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.
-
Thanks, Paul. Appreciate the quick response and all set.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!