0

I am trying to validate the Ticket Number field for certain task types and i am trying to validate the Manager email field for certain task types.

My fields are like this:

Task Type (Radio button selection):

Option 1, Option 2, Option 3, Option 4, Option 5

Ticket Number (Single line of text field)

Manager Email (Multi Selection Field)

I am trying to validate that if task types 1-3 are selected, that the ticket number cannot be blank. But I am also trying to validate the manager email field is not blank for options 3-5.

My current formula validates the ticket number field for options 1 and 3, but I don't know how to add in the manager email field validation as well.

=IF(OR([Task Type]="Option 1",[Task Type]="Option 3"),IF([Ticket Number]="",FALSE,TRUE),TRUE)
4
  • What is the type of Manager Email? is it multi choice field or multi allow people picker field? Commented Aug 10, 2022 at 3:47
  • It is a multiple choice field. Commented Aug 10, 2022 at 14:37
  • Ganesh is correct, we can't use Multi Choice field in validation formula to check whether it's empty or not Commented Aug 10, 2022 at 14:38
  • dang. ok. i guess i am stuck then Commented Aug 10, 2022 at 14:40

1 Answer 1

1

Validation of Manager Email field is not possible using list validation formula as multi-selection fields (Choice or Person/group) are not supported in SharePoint formulas.

If you are using SharePoint online modern experience, you have to customize the list form using Power Apps to apply validation for Manager Email field.

Check below threads for more information:

  1. Validation for ComboBox
  2. Validate dropdown/combobox is not blank
4
  • I think requirement is to just validate whether manager email is added or not based on some condition i.e. Required validation, Commented Aug 10, 2022 at 4:39
  • 1
    Yes, but as it is a multiple selection field, it cannot be used in formula to check if it is empty or not. Commented Aug 10, 2022 at 5:09
  • I just want to check and make sure it is not blank, is that not possible with the multiple choice field type? Commented Aug 10, 2022 at 14:36
  • Unfortunately, not possible. In order to check if it blank or not you have to refer the column in formula, which is not supported in SharePoint. Commented Aug 10, 2022 at 14:45

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.