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.

Thank you

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!