formula for the %completion in parent
Hi All,
I am trying to replicate the %completion formula in googlesheets in order to understand the value of a project based completion of the various subtasks.
Does smartsheets have this ability inherently?
The project guys always think they are further along on the project than they actually are and this is artificially inflating revenue and dragging out the project timelines.
I want to be able to go through each subtask individually and challenge them with the time left to complete as a cost versus the revenue that is available to be recognised on the project.
A formula to replicate the %completion of the various parents (outside of editing the actual smartsheet) would be super helpful.
Any thoughts?
Regards,
Raymond
Comments
-
Hi Raymond,
Is this what you're looking for?
=SUM(CHILDREN()) / COUNT(CHILDREN())
I hope this helps you!
Best,
Andrée Starå - Workflow Consultant @ Get Done
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
=AVG(CHILDREN()) works too...
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!