Forum Discussion
Solved
SharePoint Column Validation - minimum and maximum values
Good afternoon, I am trying to create a list validation formula in SharePoint and need some help on the second part. The list in question has a column called "Serial Number" and the list owner wo...
Ann_DAS Try using formula like:
=AND(LEN([Serial Number])>7,LEN([Serial Number])<10)OR
=OR(LEN([Serial Number])=8,LEN([Serial Number])=9)Length should be exactly 8 or 9.
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.
Ann_DAS Try using formula like:
=AND(LEN([Serial Number])>7,LEN([Serial Number])<10)
OR
=OR(LEN([Serial Number])=8,LEN([Serial Number])=9)
Length should be exactly 8 or 9.
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.
- Excellent, It works like a charm. Thank you
