Forum Discussion
AshMSport
May 02, 2024Copper Contributor
SharePoint Online List Column Validation on Multiple Fields Not Working
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 ...
ganeshsanap
May 02, 2024MVP
AshMSport Try this:
- Use choice column with Yes and No choices instead of Yes/No (Boolean) column.
- Make sure all your choice columns referred in formula allows single selection only.
- Use formula like:
=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:
- Sometimes comma( , ) does not work in formula (it is based on language or regional settings of your SharePoint site). So in that case use semicolon( ; ) instead of comma( , ).
- Use correct display name of your SharePoint columns in above formula.
- Wrap column names inside [] if your column name has space in it. For example: [My Column Name].
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.
- AshMSportMay 02, 2024Copper Contributor
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.