Percent Complete of Status Column

Brandon Rago

I am looking to have the Parent row show the sum of percent complete for children in the status column. Based on the photo attached, the formula I am using is not calculating the "Activity 1" cells being marked complete.

I am using the formula:

=COUNTIFS(CHILDREN([Status]@row), "Complete") / COUNT(CHILDREN([Status]@row))

Paul Newcome

The CHILDREN() function only evaluates immediate child rows. Try the DESCENDANTS function instead.

Paul Newcome

The CHILDREN() function only evaluates immediate child rows. Try the DESCENDANTS function instead.

Brandon Rago

@Paul Newcome Thank you!