% complete based on children task status
I'm hoping Paul or Tomasz or any other wonderful Smartsheet guru can help us.
We have a project plan and we'd like to indicate the % complete for each phase based on the status count of the children tasks (as opposed to by date or duration).
For example, we have Phase 1 and Phase 2 with four subtasks each in various statuses. Phase 1 has 3 Complete and 1 Blocked. We'd like a % complete column to show 75% based on 3/4 for Phase 1. Phase 2 has 2 Complete and 2 In Progress. We'd like the % complete to reflect 50%.
I added a couple of "helper" columns while I tried numerous different formulas before finally giving in to ask the community. Task Count: =COUNT(CHILDREN()). Phase level: =COUNT(ANCESTORS()).
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!