SOLVED

# List validation in Sharepoint

Copper Contributor

# 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

best response confirmed by Larsi00 (Copper Contributor)
Solution

# Re: List validation in Sharepoint

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

1 best response

Accepted Solutions
best response confirmed by Larsi00 (Copper Contributor)
Solution

# Re: List validation in Sharepoint

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