Update Status Column based % Complete, Finish Date and Today
I am trying to work out the correct formula so my Status Column updates automatically based on % Complete, Finish and Today's date.
I am using this formula for the Progress Column:
=IF(Status@row = "At Risk", "Red", IF(Status@row = "Pending", "Yellow", IF(Status@row = "In Progress", "Green", IF(Status@row = "Complete", "Blue"))))
But I am unable to land on the correct formula for the Status Column.
Help Article Resources
Check out the Formula Handbook template!