Automatically Updated DropDown List

Lila De Vera

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?

Thanks

Paul Newcome

You would need to automate the remaining choices as well. If you have a formula in a cell and then manually change the selection, it will override and delete the formula.