OR formula help

I tried to modify the OR formula and combine it with a function involving RYG symbols:

=IF(OR(IF(TODAY() - [Order Due Date]2 > 0, "Red"), IF(ISBLANK([Order Date]2, "Red")), IF(TODAY() - [Order Due Date]2 > -4, "Yellow", "Green")))

There are basically 3 columns: Order Date, Order Due Date, and status (RYG). I am trying to get the status to be "Red" if either the due date is past or if the order date is blank, "Yellow if the due date is coming up in 4 days, and "Green" all other times. I may have to resort to two separate formulas for this one.

I keep getting an error no matter what I do.

Find more posts tagged with

Formulas

Project Management

Comments

MattH

Try:

=IF(DATEONLY([Order Date]1) > DATEONLY([Order Due Date]1), "Red", IF(DATEONLY([Order Due Date]1) < TODAY(4), "Yellow", "Green"))

Jacob H.

Thanks Matt,

I just modified it a little to use TODAY instead of Order Date and it works great:

=IF(DATEONLY(TODAY()) > DATEONLY([Order Due Date]2), "Red", IF(DATEONLY([Order Due Date]2) < TODAY(4), "Yellow", "Green"))