I have a column called
Due Date and a calculated column called
I am using the following formula in
=IF(AND((Progress Status)="Not Started",(Due Date)<Today),"Overdue",IF(AND((Progress Status)="In Progress",(Due Date)<Today),"Overdue","On Track")).
However, this doesn’t seem to be working – a task with a due date set for last week hasn’t switched over to Overdue and stays on ‘On Track’. I am trying to say that if the Due Date is after today and the Progress Status column is either Not Started or In Progress, change the Task Tracker to Overdue. Thank you in advance!