Smartsheet Hierarchy % Complete Formula

Champ

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

AravindGP

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