Validation Settings in SharePoint
1 Topic
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 would like to make sure that each entry for that field contains 8 characters and possibly one extra character (example: Serial Number can be 12345678 or 12345678B). Is there a way to set a validation formula for minimum and maximum values such as "must be greater than 7 characters but less than 10"? I've managed to get "=LEN([Serial Number])>=7" to work but can't figure out the other half. Any ideas?Solved5.8KViews0likes2Comments