Help with Health Column

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

Best Answers

  • JC Mejia
    JC Mejia
    Answer ✓

    Hi Zachary,

    Your formula worked perfectly.

    Thank you very much!

    -JC

Answers

  • JC Mejia
    JC Mejia
    Answer ✓

    Hi Zachary,

    Your formula worked perfectly.

    Thank you very much!

    -JC

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!