I have a SharePoint online custom list which contains 2 columns:

  1. StartDate of type Date Time

  2. Status of type Choice field which have values such as Open, In-Progress, Closed.

Now I want to write a list validation formula to make the StartDate required in case the Choice field that is selected = In-Progress? is this possible?

1 Answer 1


Yes, it is possible using list validation formula. Use formula like below in List settings > Validation settings:

=IF([Status] = "In-Progress", NOT(ISBLANK([StartDate])), TRUE)


=IF([Status] = "In-Progress", IF(ISBLANK([StartDate]), FALSE, TRUE), TRUE)

Follow steps given here to add formula to list validation settings: How to have validation for calculated column

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.