RGYB Automation

reynaldoloera

I'm having issues with the following formula and I'm not sure why.

 

Task Formula below:

=IF(ISBLANK([Start Date]@row), "Blue", IF([Start Date]@row >= TODAY(), "Blue", IF(AND([At Risk]@row = 1, [End Date]@row <= TODAY()), "Red", IF(AND([End Date]@row <= TODAY(3), [% Complete]@row < 0.75), "Yellow", IF(AND([Start Date]@row <= TODAY(), [% Complete]@row >= 0), "Green")))))

At Risk Formula below:  (for transparency)

=IF(COUNTIF(CHILDREN(), 1) > 0, 1, IF(AND([End Date]@row <= TODAY(3), [% Complete]@row < 0.75), 1, 0))

Problem Below:

Not sure why the health status isn't working once the end date <= TODAY(), "Red".  The formula works in almost all activities except for a few through our plan.  Maybe it's not structured correctly.  Any help would be much appreciated.

 

 

 

Mike Wilday

At first glance... 

1. Your red health isn't firing because your at risk flag isn't turned on. 
2. Your at Risk isn't triggering a flag because your formula for at risk says fire a flag if its past due and its less than 70% complete.

Possible solution: You might want to rewrite the health formula to just look at the end date, and anything less than 100% complete. Don't make it dependent on the at risk flag. 

reynaldoloera

Thanks for pointing that out.  Once I reworked it everything started working

Mike Wilday

Awesome! Glad I could be of help!