Help with Health Column

JC Mejia

Hello,

I need help creating a formula for the health column. Here is what im trying to do:

If due date is 2 days or more away: Green

=IF([Due Date]@row > TODAY(1), "Green")

If due date is day before or day of: Yellow

=IF(OR([Due Date]@row =TODAY(), [Due Date]@row = TODAY(1)), "Yellow")

If due date is past due: Red

=IF([Due Date]@row < TODAY(), "Red")

If check box is checked: Blue

=IF(Complete@row = 1, "Blue")

This is my formula when using Green, Yellow, and Red:

=IF(OR([Due Date]@row = TODAY(), [Due Date]@row = TODAY(1)), "Yellow", IF([Due Date]@row > TODAY(1), "Green", IF([Due Date]@row < TODAY(), "Red")))

But, I can't seem to figure it out when I try to add Blue.

Any help would be greatly appreciated!

-JC

Zachary Mitchell

Hi JC,

Try the following formula:

=IF(Complete@row = 1, "Blue", IF([Due Date]@row > TODAY(1), "Green", IF(OR([Due Date]@row = TODAY(), [Due Date]@row = TODAY(1)), "Yellow", IF([Due Date]@row < TODAY(), "Red"))))

I added the Check box condition to the front so that it would override all other conditions. Hope this helps

-ZM

JC Mejia

Hi Zachary,

Your formula worked perfectly.

Thank you very much!

-JC

Zachary Mitchell

Hi JC,

Try the following formula:

=IF(Complete@row = 1, "Blue", IF([Due Date]@row > TODAY(1), "Green", IF(OR([Due Date]@row = TODAY(), [Due Date]@row = TODAY(1)), "Yellow", IF([Due Date]@row < TODAY(), "Red"))))

I added the Check box condition to the front so that it would override all other conditions. Hope this helps

-ZM

JC Mejia

Hi Zachary,

Your formula worked perfectly.

Thank you very much!

-JC