Simple task health formula issue
I am using this formula that I adapted to my comun names from one that was posted here elsewhere.
=IF(AND(Start@row > TODAY(), [% Complete]@row = 0), "Blue", IF(AND(Start@row < TODAY(ROUND(Duration@row / 2)), [% Complete]@row >= 0.5), "Green", IF(AND(Start@row > TODAY(Duration@row * 0.5), [% Complete]@row < 0.5), "Yellow", IF(AND(Start@row > TODAY(Duration@row * 0.75), [% Complete]@row < 0.75), "Red"))))=
and it works for most rows but I get #INVALID DATA TYPE for some rows but not able to determine what's going on with those rows, but it seems like the rows that should be "Red" or "Yellow" are the root cause. (The 'Duration Complete' is just there to compare % Complete to how much of the planned schedule for that task has been consumed. Maybe there is a better way to just compare those values?
What am I doing wrong? Thanks so much for any help anyone might offer.
Help Article Resources
Check out the Formula Handbook template!