IF OR/AND Nesting Part 2

Hi - I just asked a IF OR/AND nesting question recently and it was answered. Then I tried to modify it slightly and it is unparseable. Could you please look at this one below?

=IF(OR(AND([Round #3 Price Sheet Status]@row = "Not Renewing"), AND([Account has Updated Renewal Added to TL]@row = 1,)), "Blue", IF([Price Sheet Deadline]@row >= TODAY(20), "Green", IF([Price Sheet Deadline]@row < TODAY(18), "Red", IF([Price Sheet Deadline]@row < TODAY(20), "Yellow"))))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!