Forum Discussion

Copper Contributor

Apr 17, 2023

Solved

Set a minimum number of characters for a SharePoint list Column

Hi everyone, So I have a SharePoint list with many columns one of them being the social security number. In order to minimize errors, I would like for people to be able to put 15 characters ...

Lists

SharePoint Online

ganeshsanap
Apr 17, 2023
SelmaA Can you try using List Validation settings instead of column validation?

Also, try using same formula on different list (without data) in same SharePoint site and different SharePoint site (with English language) and see if it is working for you.
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.
For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

ganeshsanap

MVP

Apr 17, 2023

SelmaA Are you trying to have the exact 15 characters in the column? If yes, then use formula like:

=IF(ISBLANK([column 1]), TRUE, IF(LEN([column 1])=15, TRUE, FALSE)

Use correct display name of your column. Also, as you are using non-English language try using LEN function equivalent in your language.

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( , ).

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.

For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

SelmaA

Copper Contributor

Apr 17, 2023

Thank you for your reply ! I did try it and still get the same syntax error message (I also tried with semicolon instead of comma and also by using the function equivalent in french).
Could it be that it is not working because I already have data on that column ?