Auto populate risk columns

edited 12/09/19 in Smartsheet Basics

Hi All,  

I am trying to change the today condition in this formula to today - 2 in order to become red few days before but it's not working. 

Does someone know how I could do it?

=IF(AND(Finish78 < TODAY(), [% Complete]78 < 1), "Red", IF([% Complete]78 = 0, "Blue", IF([% Complete]78 < 1, "Yellow", IF([% Complete]78 = 1, "Green", "error"))))


Thank you!!