Can someone tell me whats wrong with this equation?

edited 03/14/23 in Formulas and Functions

I'm looking to get Yellow when the due date is between 5-0 days, Red after one day late and otherwise green.

=IF(AND(([Target End Date]@row) = TODAY(), ([Target End Date]@row - 5) >= TODAY()), "Yellow", IF(TODAY() > ([Target End Date]@row + 1), "Red", IF(TODAY() > ([Target End Date]@row - 6), "Green")))


  • Nick Korna
    Nick Korna ✭✭✭✭✭✭

    Hi @Kenny13,

    If I've understood properly this is the outcome you're looking for:

    With the formula being:

    =IF(TODAY() > [Target End Date]@row, "Red", IF(TODAY(5) >= [Target End Date]@row, "Yellow", "Green"))

    If I've misunderstood something or you've questions etc. then just post! 😊

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!