Sharepoint List validation formula help

Question

Hi

I am trying to add a validation setting to my list, however my formula isn't working.

If someone changes the status column to "completed" I then want the date completed flagged as a required field and the % complete column to flag as requiring 100% and no less before they can save the changes. The % completed column value is defaulted to 0%, not blank.

=IF(Status="Completed",IF(ISBLANK([Date Completed]),IF([% Complete]<100),FALSE,TRUE),TRUE))

Answer 1

Hi @Siddrow,

Please use the below formula. As per my test, it works perfectly in my environment. The reason why your formula is not working I think is that ISBLANK function does not work for a date and time column.

=IF(status="Completed",IF(OR([Date Completed]="",[% Complete]<1),FALSE,TRUE))

---

If the answer is helpful, please click "Accept as 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.