Forumla Help, Nested IFs

@SPark ✭✭✭
edited 12/09/19 in Formulas and Functions

Hi, Looking to see if someone can help me with this formula. I would like it to follow the following logic:

  1. If Task is checked as complete= "Green"
  2. If Task is past complete by date and not checked as complete= "Red"
  3. If Task is 3 days until complete by date and not checked as complete ="Yellow"

Here is the what I have but it's not working.

=IF([Task Complete]@row, "Green", IF([Complete By]@row > TODAY(-3), "Yellow", IF([Complete By]@row >= TODAY(), "Red")))

Thank you!!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!