May 02 2024 06:02 AM
I'm trying to enforce validation in an out of the box SharePoint list. When a value is selected in a choice column eg. Column A = 1, I want six other columns to become required. The column types are as follows:
Column B: Yes/No Column C: Choice Column D: Single line of text Column E: Single line of text Column F: Single line of text Column G: Single line of text
Validation syntax: =IF([Column A]="1",AND(NOT(ISBLANK([Column B])),NOT(ISBLANK([Column C])),NOT(ISBLANK([Column D])),NOT(ISBLANK([Column E])),NOT(ISBLANK([Column F])),NOT(ISBLANK([Column G]))),TRUE)
Issue 1: It doesn't work on Yes/No type of column (Column B) i.e. I can submit the form by leaving it blank, but if I change it to Single line of text it works.
Issue 2: It allows me to submit the form If I select a value in Column C and leave everything else blank.
Issue 3: When I remove Column C from the syntax I can submit the form by leaving all required fields empty.
For issue 1: Tried changing column type to text, it worked but tried on another Yes/No type column, it didn't work. tried on a different list in a different site collection. For issue 2 and 3:
May 02 2024 07:35 AM
@AshMSport Try this:
=IF([Column A]="1",IF(OR(ISBLANK([Column B]),ISBLANK([Column C]),ISBLANK([Column D]),ISBLANK([Column E]),ISBLANK([Column F]),ISBLANK([Column G])),FALSE,TRUE),TRUE)
Note:
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.
May 02 2024 09:22 AM
@ganeshsanap Not working. I'm able to submit the form by filling data in just Columns B and C. Tried using semi colon also, nogo.