1

Goal

I have a "Managed Services" Choice column with predefined choices displaying as Checkboxes (allow multiple selections). I want to make another column required based on the selection of the "Managed Services" dropdown.

I used Library Validation on a SharePoint Online List with the new experience enabled.

Problem

I can not Save my Validation Settings: The formula contains a syntax error or is not supported.

Error

My Columns

Overview

Overview of my columns

Managed Services

Managed Services column

Examples

If "Managed Services" equals "Managed Service für Client" set "Produkt Client" required

If "Managed Services" equals "Managed Service für Server" set "Produkt Server" required

What I have tried so far

=IF([Managed Services]="Managed Service für Client",IF(ISBLANK([Produkt Client]),FALSE,TRUE),TRUE)

What I have tried so far

1 Answer 1

0

This is a known issue with SharePoint formulas.

Multi-selection fields (Choice or Person/group or lookup) 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 list form fields.

1
  • 1
    Thank you very much. I will try to solve it using a Power App. Aug 11, 2022 at 6:50

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.