I have a text field into list in sharepoint online, I want to know if there is a formula I can add to column format to only accept no more than 6 characters. or there is some javascript or jquery to validate it? Regards


I think you can use the Column settings for the text field where you can specify the maximum characters.enter image description here

Or you can specify it in the column validation settings where you can set the formula and custom message enter image description here

  • 1
    Just a nit pic... The formula above can be shortened to =LEN(UserName) < 7 as the expression is a Boolean that already returns true or false. – Mike Smith - MCT - MVP May 4 '18 at 2:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.