Automatically Updated DropDown List

Hi everyone,

I have a drop down list that contains complete, in progress, overdue/delayed, and rescinded. These are displayed in the Status column.

I also have a column that lists the due date.

When it is one day after the due date, is their a way to automatically have the status column update to overdue/delayed?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!