We have two columns,Status(choice) and Date(Date and Time). Now I want to make the Date column mandatory when the Status = Approved.

I'm currently using this calculated values

=IF(AND([Status]="Approved",ISBLANK([Date])),"Not OK","OK")

The validation is working fine, but when I fill the Date column, it still says the Date column is not filled.

Any suggestions?

1 Answer 1


Go to list setting --> Under general setting go to Validation setting and use below formula. This will make date field mandatory if status is Approved


Formula says if Status is Approved and Date is empty validation is false else true. Hope this helps !

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.