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?
    – harshal gite
    Commented Jan 29, 2020 at 6:41
  • Colleague is a people picker column
    – mtagliaferri
    Commented Jan 29, 2020 at 21:51
  • You cannot use people picker in any formulae
    – harshal gite
    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...
    – mtagliaferri
    Commented Jan 29, 2020 at 21:48
  • Are you getting error while saving the column formula? Or getting incorrect results while saving items?
    – Ganesh Sanap - MVP
    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.

Not the answer you're looking for? Browse other questions tagged or ask your own question.