1

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!

Thanks

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

1 Answer 1

Reset to default
0

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))

References:

  1. Calculated Field Formulas.
  2. Examples of common formulas in SharePoint Lists.
Improve this answer
2
  • Thanks but it seems to have an error... Commented Jan 29, 2020 at 21:48
  • Are you getting error while saving the column formula? Or getting incorrect results while saving items? Commented 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.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.