8

I am in need for the status colum 1 (red, yellow, green) to automatically change when column 2 (date) is passed column 3 (date). Can this be done with a formula? 

I can do "=IF([Approved Required Delivered Date]1 < [Adjusted Delivery Date]1, "Red")", however, I am sure on how to add the other two conditions in the formula.

Thank you,

 

Comments

Hi Roberto,

try this:

=IF([Date1]@row < [Date2]@row; "Red"; IF([Date1]@row = [Date2]@row; "Yellow"; IF([Date1]@row > [Date2]@row; "Green")))

Regards

Andreas

 

In reply to by Andreas S.

Andreas, I tried your recommendation; however, it is coming up with a #UNPARSEABLE message. This is what I entered:

 

=IF([Approved Required Delivered Date]1<[Adjusted Delivery Date]1,"Red"; IF([Approved Required Delivered Date]1>[Adjusted Delivery Date]1,"Green"; IF([Approved Required Delivered Date]1>[Adjusted Delivery Date]1, "Green")))

 

In reply to by Roberto Sanchez

Hi Roberto,

Try this. 

=IF([Approved Required Delivered Date]1<[Adjusted Delivery Date]1,"Red", IF([Approved Required Delivered Date]1>[Adjusted Delivery Date]1,"Green",IF([Approved Required Delivered Date]1>[Adjusted Delivery Date]1, "Green")))

Did it work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting