IF 30 days past Planned end date show red
I am trying to create a formula that looks at Planned End Date and determines the following:
If <= Today then Green
IF 1 day past planned end date then Yellow
IF 30 days past end date then Red
=IF([PLANNED END DATE]@row(30), "Red", IF([PLANNED END DATE]@row(1), "Yellow", IF([PLANNED END DATE]@row=TODAY)
Can I do this without having to create a helper column?
Help Article Resources
Check out the Formula Handbook template!