If(OR(AND statement

Chritine Cianci

little help - been working on this too long

If the %complete is100%, ie. =1 then the ball should be gray no matter what

If the job is not 100% and finish date has past, then red,

If the job is not 100% and finish date is within 7 days, then yellow,

otherwise green

=IF(OR(AND([%Complete]@row = 1, "Gray"), OR(AND([Finish@row] < TODAY(), [%Complete@row] <>1), "Red", OR(AND([Finish@row] < TODAY() + 7, [%Complete@row] <>1),"Yellow", "Green"))))

Debbie Sawyer

Try this

=IF([%Complete]@row = 1, "Gray", IF(AND(Finish@row < TODAY(), [%Complete]@row <> 1), "Red", IF(AND(Finish@row < TODAY(7), [%Complete]@row <> 1), "Yellow", "Green")))

Hope it helps

Kind regards

Debbie