In a SharePoint list I want to make the End Date Required when the Task Status = Complete

Marcia Bester 20 Reputation points


I am busy setting up KPI's via a SP list.

In this I have fields, Task Status and End Date, I want the End Date to become required when the Task Status is changed to Completed. I also want to ensure that the End Date may not be the same as the Start Date or earlier than the Start Date

I have looked for similar questions, however most are about choice field. I am not able to use Power Apps or Tools

A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
8,598 questions
0 comments No comments
{count} votes

Accepted answer
  1. Emily Du-MSFT 36,776 Reputation points Microsoft Vendor

    Please go to List settings -> Validation Settings -> Use following formula.

    =IF([Start Date]<[End Date], IF([Task Status]="Completed", IF([End Date]="",FALSE,TRUE),TRUE))

    User's image


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

0 additional answers

Sort by: Most helpful