SharePoint Column Validation

%3CLINGO-SUB%20id%3D%22lingo-sub-1625712%22%20slang%3D%22en-US%22%3ESharePoint%20Column%20Validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1625712%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20column%20where%20they%20will%20enter%20in%20a%20contract%20number%20but%20I%20need%20the%20contract%20number%20to%20have%20up%20to%20three%20uppercase%20letters%2C%20dash%20with%20no%20space%20and%20then%205%20digits%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EL-NNNNN%3C%2FP%3E%3CP%3ELLL-NNNNN%3C%2FP%3E%3CP%3ELLL-NNNNN%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20sure%20how%20to%20do%20this%20and%20need%20some%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1625712%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Senior Member

I have a column where they will enter in a contract number but I need the contract number to have up to three uppercase letters, dash with no space and then 5 digits

 

L-NNNNN

LLL-NNNNN

LLL-NNNNN

 

I'm not sure how to do this and need some help.

 

0 Replies