Auto populate risk columns

Nathiele

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!!

Mike Wilday

Hi there, just add -2 in the parenthesis of Today() like below. 

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

 

Nathiele

Thank you. 

Mike Wilday

You're welcome.