I have the following validation rule that works perfectly which makes mandatory [Customer] and [Member] columns if column [Feedback Type] equals "Ticket" from a drop down list:

=IF([Feedback Type]="Ticket",AND([Customer]<>"",AND([Member]<>"")),TRUE)

I need further validation rule but have no idea if it is possible to build further validations; what I also need is:

If [Feedback Type] equals "Ticket" or "Customer" from a drop down list then [Customer] and [Member] must be mandatory.

Ideally I would like also the following validation rule included:

If the column [Feedback Type] equals "Colleague" from a drop down list then [Colleague] must be mandatory but not [Customer] and [Member]

Hope the above makes sense!


  • Is "Colleague" a people or group field? Jan 29, 2020 at 6:41
  • Colleague is a people picker column Jan 29, 2020 at 21:51
  • You cannot use people picker in any formulae Jan 30, 2020 at 16:57

1 Answer 1


Try using below formula:

=IF([Feedback Type]="Colleague", IF(ISBLANK([Colleague]), false, true), IF(OR([Feedback Type]="Ticket",[Feedback Type]="Customer"), IF(OR(ISBLANK([Customer]),ISBLANK([Member])), false, true), true))


  1. Calculated Field Formulas.
  2. Examples of common formulas in SharePoint Lists.
  • Thanks but it seems to have an error... Jan 29, 2020 at 21:48
  • Are you getting error while saving the column formula? Or getting incorrect results while saving items? Jan 30, 2020 at 2:33

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.