I've tried a plethora of solutions from other posts, however I am having no luck.

I would like to make FieldA, FieldB, and FieldC required if Dropdown1 is set to 'WON' when creating an item in my SharePoint list, meaning the item cannot be saved until FieldA, FieldB, and FieldC contain some information.

What formula would I use in List validation to achieve this?

Thank you.

1 Answer 1


Use this formula:

=IF([Dropdown1]="WON", IF(OR(ISBLANK([FieldA]), ISBLANK([FieldC]), ISBLANK([FieldC])), FALSE, TRUE), TRUE)

You have to add this formula under List Validation settings.

Follow below steps:

  1. Go to SharePoint list
  2. Click on Settings icon and select List settings
  3. Select Validation settings
  4. Add formula & user message and click Save

Related threads:

  1. Validation Column Not Working
  2. List validation if then syntax


  1. Sometimes comma(,) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).
  • 1
    Oh Wow! Amazing, thank you so much this worked perfectly!!
    – Ellie
    Commented Oct 17, 2022 at 15:56

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.