Forum Discussion

Copper Contributor

Jun 06, 2023

Solved

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 nee...

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

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.