The task list can be used to track and record work tasks, and summarize the overall completion status of the extended tasks in the status report. For example, if the planned completion time is earlier than today, this indicates that the task is faulty. You can mark it as red.
Implementation Method:
- Add a calculation column for whether to extend the task list in Sharepoint. The type is Boolean and the formula is set= [Planned completion date] <Today ()
- Create an attempt for the task list to filter only projects that are postponed
- Create a new status item in the status list to summarize the number of projects that have been extended. If the number is greater than 0, the item is marked red.
For more information about the public announcement, refer to the official website of Microsoft.
Note that today's date can be obtained using the today () function.
[Original] how to determine whether the task has been extended in SharePoint