Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

OR formula help

Jacob H.
Jacob H. ✭✭✭✭
edited 12/09/19 in Archived 2017 Posts

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.


  • MattH



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

  • Jacob H.
    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"))



This discussion has been closed.