Forum Discussion

Brass Contributor

Nov 14, 2022

Solved

Validate Column is either NULL or has 11 characters

The SharePoint List has a Single Line of Text Column. In this column any combination of letters and numbers can be entered. I need these two validations to run: 1] The field can be NULL / BLANK / ...

ganeshsanap
Nov 15, 2022
Acorn999 Try using this validation formula:

=OR(ISBLANK(MEMBERMBI),LEN(MEMBERMBI)=11)

Note: Sometimes comma(,) does not work in formula (it is based on language or regional settings on your site). So in that case use semicolon(;) instead of comma(,)

Similar thread: Error in Formula in List Validation Settings
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

Nov 15, 2022

Acorn999 Try using this validation formula:

=OR(ISBLANK(MEMBERMBI),LEN(MEMBERMBI)=11)

Note: Sometimes comma(,) does not work in formula (it is based on language or regional settings on your site). So in that case use semicolon(;) instead of comma(,)

Similar thread: Error in Formula in List Validation Settings

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.

Acorn999
Brass Contributor
Nov 15, 2022
This resolved the issue. Very appreciated. Also the formula is entered in "column validation" and it works there. If I now go to "list validation" the same formula shows there. Next time for any issue, I will try entering the formula in both places and also try replace comma with semicolon.