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

Options
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.

Tags:
· Share on FacebookShare on Twitter

Comments

  • MattH
    MattH ✭
    Options

    Try:

     

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

    · Share on FacebookShare on Twitter
  • Jacob H.
    Jacob H. ✭✭✭✭
    Options

    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"))

    Regards,

    Jacob

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories