Help with a Formula for Status Change

Armando D Garcia

I want to create a formula that changes the status colors to red, yellow or green. Below are the criteria:

IF Due Date is < Today and progress bar is not "Full", then "Red".

IF Due Date is > Today - 3days, and progress bar is not "Three Quarters", then "Yellow"

All other scenarios = "Green"

Any help or suggestions would be appreciated.

Thank you

Mark Cronk

Hi@Armando D Garcia ,

Try:

=IF(AND([due date]@row<today(), [Progress bar]@row <>"Full"), "Red", IF(AND([due date]@row>today(-3), [Progress bar]@row<>"three quarters"), "yellow", "green")

Mark

Mark Cronk

Hi@Armando D Garcia ,

Try:

=IF(AND([due date]@row<today(), [Progress bar]@row <>"Full"), "Red", IF(AND([due date]@row>today(-3), [Progress bar]@row<>"three quarters"), "yellow", "green")

Mark

Armando D Garcia

Thanks, Mark. It worked! Your help and insight was very much appreciated.