Changing Drop Down Value Based On Current Date?

edited 12/09/19 in Formulas and Functions

I am trying to change the drop down value on my Health column based on the current date. Is this possible?

ie. If the start date value is in the past, the health column changes to "At Risk" which is one of the drop down choices.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!