Contents
In my testing, when Due Date is passed, the color of the value is changed to Red: This only applies to the SharePoint App Task list: To have passed Due date display in red the Check mark column must be included. Add it to the View and it displays passed due dates in red.
Based on the wording of your question, it sounds like all you’re wanting to do is add additional date fields to the list and manually update those fields and have them display in your list views? If you’re wanting to monitor the record and have it automatically update the date fields, this can be done using SharePoint workflows.
How to track the completion date of a task?
Recording completion date of task when it is marked as completed. ( In your case a check box so below formula may change or you) This will capture the date when task is marked completed in the task list. 2. To track tasks which are already completed and there dates.
Is it possible to color code a SharePoint list date?
For Modern UI: Yes, you can use json formatting to conditionally color fields in sharepoint online. The following example colors the current date field red when the value inside an item’s ExpirationDate is before the current date/time. Source: Use column formatting to customize SharePoint.
So to get the Highlighting shown above we need this setup: So, when Highlighter checks the list, first it checks to see if the item’s due date is less than 7 days after today, if it is Highlighter colors the row orange and moves on to check the next list item.
How to display past due date in red?
To display the past Due date column in red, there is the only requitement – “Due date” column should show date only (not sate and time), change that in the column’ settings. Thanks for contributing an answer to SharePoint Stack Exchange!