Auto changing status based on due date
Hi, i am hoping this is possible and someone can help?
We have created a sheet which is populated from a form and is working really well. We populate the "Required completion date" base on the type of issue and this is automated and again working very well.
What i would like to achieve is an automatic change to the status when the required completion date is in the past.
We currently have 4 status options. Not Started, In Progress, Complete and Overdue.
Is it possible to change the status to "Overdue" if the "Required Completion Date" is in the past and the status is not completed?
Any help would be wonderful.