Forum Discussion
Set a minimum number of characters for a SharePoint list Column
- 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
So far I know, you can set a minimum number of characters for a SharePoint list column by using column validation.
In the column settings, under the “Column Validation” section, you can enter a formula to validate the input.
For example, to set a minimum of 15 characters for a single line of text column, you can use the formula =LEN([Column Name])>=15.
Replace [Column Name] with the actual name of your column.
Make sure that the formula is entered correctly and that there are no spelling errors.
I hope that I could help with that!
- SelmaAApr 17, 2023Copper ContributorThank you for your reply ! This is what I tried and it is not working and I can't figure out why.
- NikolinoDEApr 17, 2023Gold ContributorI'm glad I could help.
I wish you continued success with SharePoint!