0

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?

Improve this question

1 Answer 1

Reset to default
0

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

=IF([Status]="Approved",IF([Date]="",FALSE,TRUE),TRUE)

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

Improve this answer

Your Answer

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

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.