Percent Complete of Status Column
Options
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))
Tags:
Best Answer
-
The CHILDREN() function only evaluates immediate child rows. Try the DESCENDANTS function instead.
Answers
-
The CHILDREN() function only evaluates immediate child rows. Try the DESCENDANTS function instead.
-
@Paul Newcome Thank you!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!