Calculate % Complete at Child Level AND Parent Level in one formula

Erin K

Hi Paul,

I figured it out!

I used this formula:

=IFERROR(AVG(CHILDREN()),

IF(Status@row = "Complete", "1",

IF(Status@row = "In Progress", ".25",

IF(Status@row = "Blocked", ".5",

IF(Status@row = "Not Started", "0",

"")))))

Then I formatted the column with Percentage