String of Text and muliple IF Conditions for Column

[Anonymous]

Hi All,

I am trying to create a new column that creates a 'status' based on when an order should be made. I can get the one condition i.e. if order by date(schedule date- leadtime - 7 days for quality checks) < TODAY, then call this a 'shortage', however, I cannot find how to add multiple conditions. The first line runs okay and will insert blanks alongside 'Shortage's, however, I want there to be 3 conditions, not two.

What I am looking for is;

If Order date < Today = 'Shortage'

If Order date is between TODAY and TODAY+7 = 'Order in Next 7 Days'

If Order date is more than TODAY+8 = 'Consider Ordering'

Thank you!

[ChrisMendoza · Accepted solution]

@Anonymous - try as:

Column =
IF (
    TableName[Order date] < TODAY (),
    "Shortage",
    IF (
        TableName[Order date] >= TODAY ()
            && TableName[Order date]
                <= TODAY () + 7,
        "Order within 7 Days",
        IF ( TableName[Order date] >= TODAY () + 8, "Considering" )
    )
)

[Anonymous]

Amazing, that worked perfectly. Thanks so much!