Mark parent row at risk if any child row is at risk?

Jamison

This would seem to be a "project settings" sort of thing, but i can't find it. Is there a formula that can accomplish this?

KrisWalsh

Using the Status Column. Parent Row

=IF(COUNTIF(CHILDREN(), "At Risk") > 0, "At Risk", "XXXX")

 

You could also make the Parent a % Complete unless a child is 'At Risk'.

=IF(COUNTIF(CHILDREN(), "At Risk") > 0, "At Risk", (COUNTIF(CHILDREN(), "Completed") / COUNT(CHILDREN())))

 

Using a Flag Column

Child Row Formula: =IF(Status4 = "At Risk", 1, 0)

Parent Row Formula: =IF(COUNTIF(CHILDREN(), 1) > 0, 1, 0)

 

RYG Layered Formula: If this row has child rows, then default to green unless it has a red or yellow child row. If it does, it will become red or yellow (red with higher priority).

 

 If it doesn't have children, turn green if Done checkbox is checked or if this task hasn't been touched yet. Turn yellow when the end date approaches in the next 7 days. Turn red if we're past the end date and complete isnt checked."

 

-=IF(COUNT(CHILDREN([Task Name]8)) > 0, IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(), "Yellow") > 0, "Yellow", "Green")), IF(Done?8 = 1, "Green", IF(ISDATE([End Date]8), IF([End Date]8 < TODAY(), "Red", IF(NETWORKDAYS(TODAY(), [End Date]8) <= 7, "Yellow", "Green")), "")))

Jamison

Oh my - I'll give a pre-emptive thank you. It may take some time to get through this.