RYG Automation using TODAY, AND, and OR functions

This discussion was created from comments split from: Automate RYG For Project Tasks.


  • Similar Goal - RYG Automation - What is wrong with my formula :

    =IF(AND(TODAY() > Finish@row, OR(Status@row = "In Progress", Status@row = "Not Started"), "Red", IF(AND(TODAY() < Finish@row, OR(Status@row = "Complete", Status@row = "In Progress"), "Green", IF(AND(TODAY() = Finish@row, OR(Status@row = "In Progress", Status@row = "Not Started")), "Yellow", IF(AND(TODAY() < Finish@row, (Status@row = "Not Started", "Gray"))))))))

  • L_123
    L_123 ✭✭✭✭✭✭
    edited 06/03/20

    =IF(AND(TODAY() > Finish@row, OR(Status@row = "In Progress", Status@row = "Not Started")), "Red", IF(AND(TODAY() < Finish@row, OR(Status@row = "Complete", Status@row = "In Progress")), "Green", IF(AND(TODAY() = Finish@row, OR(Status@row = "In Progress", Status@row = "Not Started")), "Yellow", IF(AND(TODAY() < Finish@row, Status@row = "Not Started"), "Gray"

    You didn't close out your first 2 and statements or the last one. Check and see if that works, if not I can troubleshoot further.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!