Sharepoint Foundation 2010 List Field Validation formula
Posted on 2012-08-14
I have spent the better part of an afternoon working on a list form. I want a Single Line of Text field to have a mininmum of 5 Characters. The characters will be two to three numbers to begin with then a username such as: 370jbrown. The five character minimum will attempt to deter them from typing their ID followed by two letters of their name.
My formula which doesn't work is: =([Trainee's ID Badge]>5) or =[Trainee's ID Badge]>5.
Neither work. My guess is the formula is doing math and not number of characters.
what would the validation formula be to count the number of characters entered, rejecting the entry if it is less than 5?