Smartsheet Hierarchy % Complete Formula
Smartsheet Community:
Does Anyone Have The Formula That Smartsheet Use to Calculate % Complete When Dependencies is Enabled in Project Settings?
I Would Like to Use That Formula for % Complete Plan As a KPI For Project Progress.
Thanks
Answers

Hi @Champ
What the formula does is basically % complete times the duration for the task over the duration in the parent row, which is the total duration of all children.
So, it will be something like =([% Complete]@row*Duration@row)/[Duration]x), where x is the row# of the parent
Thanks,
Aravind GP Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 218 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!