RGYB Automation
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.
Comments

At first glance...
 Your red health isn't firing because your at risk flag isn't turned on.
 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.

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

Awesome! Glad I could be of help!
Help Article Resources
Categories
Check out the Formula Handbook template!