Hoping someone can help as I am relatively new to Sharepoint. I've created a list to track completion of internal audit activity. It includes a status column and due date column. I'm trying to create a calculated column which determines if the item is overdue if the status is not complete.

Can someone please assist?



1 Answer 1


You can create a new view and add a filter to it - exclude anything where Status=Completed, since you don't want completed items to show up as overdue. That covers one of your requirements.

To calculate overdues, you'll need to use something which works ofd the [Today] date.

Here are some posts to existing questions and answers that should help you. This existing post does something similar. You might find this post of use too. This post also looks useful.

  • Is a calculated field going to solve the issue, as the calculation only takes place then the item is updated. Unless some timer job will update the items when they expire? Jul 25, 2018 at 20:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.