Forum Discussion

Larsi00's avatar
Larsi00
Copper Contributor
Jun 07, 2023

List validation in Sharepoint

Hi,

 

I need to build a formula which is applied to multiple fields in a list. The logic is as follows:

 

If alternative "a" in choice field "b" is selected, then make field "c" mandatory.

I need to repeat this logic for multiple fields ( such as "c"), where the the selection in choice field "b" determines if some fields are mandatory to fill out or not.

 

Let's say I have 5 fields that becomes mandatory when alternative "a" in choice field "b" is selected, otherwise not.

 

How do I build this into one formula?

 

Thanks!

 

/Lars

 

  • ganeshsanap's avatar
    ganeshsanap
    Jun 07, 2023

    Larsi00 I don't know if I understood all your requirements. But, here is example formula which will give you idea to create your own formula based on the logic. 

     

    =IF([Column B] = "A", IF(OR(ISBLANK([Column C]),ISBLANK([Column D]),ISBLANK([Column E])),FALSE,TRUE))

     

    If value of Column B is equal to A, Column C, Column D and Column E will be mandatory.

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

  • ganeshsanap's avatar
    ganeshsanap
    MVP
    Jun 07, 2023

    Larsi00 I don't know if I understood all your requirements. But, here is example formula which will give you idea to create your own formula based on the logic. 

     

    =IF([Column B] = "A", IF(OR(ISBLANK([Column C]),ISBLANK([Column D]),ISBLANK([Column E])),FALSE,TRUE))

     

    If value of Column B is equal to A, Column C, Column D and Column E will be mandatory.

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Resources