SharePoint List Validation

Mark Wilson
Mark Wilson used Ask the Experts™
on
Hi

SP2013

I have single text field as part of a list and I need some validation setting up on it

The field has a default value of Unknown. The user can also input values such as 12345678-02.

The validation will be that the value in the field can be Unknown or if it is not Unknown the 9th character must be a dash i.e. -, as in the example above.

Any suggestions welcolme
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Software/web developer
Commented:
The validation formula is (assuming the field name is "Field1"):

=OR(Field1="Unknown",AND(LEN(Field1)>=9,MID(Field1,9,1)="-"))

Open in new window


If field name has spaces - use its internal name or enclose the name in brackets like this:

=OR([Field 1]="Unknown",AND(LEN([Field 1])>=9,MID([Field 1],9,1)="-"))

Open in new window

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial