Thursday, April 7, 2016

Overdue date not marked in red in SharePoint Online Task Lists

Hi folks,

Been a while since I've posted anything SharePointy.
One reason is the migration to Exchange that I was recently involved with and it's in fact still not completed, so expect Part 2 of the post anytime soon(ish) - it will include GMail to Office365 stuff.

Now, I've found out that whenever your dates in an out of the box task list become overdue, they are NOT marked in red if you've changed the Due Date column to include the time (and not just date).

Strange, isn't it? Yes, so you can't really use this as a very precise task/time tracking solution (yet).

Default (Due Date = Date Only) and today's date = 07/04, so any task before that should be RED.


Including the time, and the task is no more overdue :) I've talked to MS about it, and hopefully it will be changed in the future by the product team (which happens to be Project for that one).


So... alternatives are for you to use some list conditional formatting...which is another big topic I might write about in the future as I've had to do it as part of a project management solution.

2 comments:

  1. Hi, I just came across your post - I don't know what I did but overdue tasks are no longer showing in red and even though I have the strike through button ticked for completed tasks, neither are appearing as they should. I have checked what you have written above and only the date is checked. Any tips? I have tried creating a different view in case I clicked something accidentally but nope, still not appearing as it should! Thanks for your help!

    ReplyDelete
  2. Hi Tahnee,

    If you're using SharePoint Online, maybe it's related with the fact that MS has disabled the HTML calculated columns in lists. If you have not requested an extension of this feature, it might be a good time to do so. For more info on that feature, you can read my other blog post here -> http://www.moresharepoint.net/2017/06/calculated-fields-with-html-in.html

    ReplyDelete