I have text field called ID Proyecto into list and I want to add column validation to accept no more than 6 digits so into Column Validation I add:

=LEN(ID Proyecto) < 7

But I get

Formula contains an error or sintaxis are wrong

I also try

=IF(LEN(ID Proyecto) < 7,TRUE,FALSE)

But same result. What am I doing wrong? Regards


If the "ID Proyecto" does not contain Space, like this format:


Then you can edit this “ID Proyecto" column in list settings and set "6" for the "Maximum number of characters" option.

enter image description here

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.