% Complete formula

BjgBjg
edited 12/09/19 in Using Smartsheet
01/15/18 Edited 12/09/19

Hi,

I need to be able to calculate the % complete of a project in the parent row based on % complete of a number of tasks in the child rows and the project duration without using Predecessors column.

 

Can anyone help??

 

Thanks,

Bill

Comments

  • Hi Bill,

    Try this out:

    ROUND(AVGW(CHILDREN([% COMPLETE1]), CHILDREN(DURATION1)), 2)

    Best,

    Kara

Sign In or Register to comment.