Multi status based on days remaining

[Katryna_Novelozo]

Hi,

I’ve set statuses “Item Good” “Item Due Soon” and “Item Due” in one table.
Relating to table where calculations occuring for “remaining days”.

I’m wanting to input logic where “item Due soon” is triggered at 60 days remaining or less, then “Item Due” at 0 days or negative.

Seems like the current logic I have is conflicting because of both less than of equal to 60 and the numbers 0 and below fall within this logic.

What is the better/right way to design this logic so that I can have all 3 statuses triggered?

[Jeff_Hager]

Work backwards. <= 60 includes zero and less than zero, so that part of the IF will always trigger first. Combine the two zero checks into one where you check less than or equal to zero. Then move that to the top of your IF logic.

[Katryna_Novelozo]

This worked brilliantly. Thanks Jeff