SharePoint Column Validation

Question

I have three fields that I'm trying to add column validation to:

Status (choice type)
Completed Date (date and time type)
Start date (date and time type)

I'm seeking a validation formula that resolves:

If [Status] = Completed, [Completed date] can't be blank, and must be >= [Start date]

Thank you

Answer 1

Hi @David Reisinger
You could apply the below formula via List settings> Validation settings> Formula to meet your need:
=IF(AND([completed date]-[start date]<0,status="completed"),FALSE,TRUE)

Then if [Status] = Completed, if [Completed date] is blank, or its value< [Start date], you will be not able to save the item and an error message will appear. You can set the User Message in the above Validation Settings page to customize the error message.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.

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.

Answer 2

Hello, thank you for the assistance - it worked perfectly! An amazing resource and incredibly kind of the person who provided the solution - thanks!

Answer 3

Have there been any changes to the Lists settings. When trying this now I am getting the following error: "The validation formula can refer to this column and not others"

Answer 4

Hi @Yi Lu_MSFT ,

I am receiving the following error message when trying to add a new "Issue" to my issue log on a SharePoint site.

I have not added any column validation to the list and have had no issues adding items previously... any ideas?