I have a list where I'd like to enforce that for one of my Single Line of Text fields, the user must enter a value with exactly 3 characters. However, the field is not required so I only want the validation error to display when the user has entered text. This is what I have in the column settings under Column Validation

=AND(LEN([My Text Field])=3,(NOT(ISBLANK([My Text Field]))))

And then I have a message in User message: Please ensure text field has 3 characters

Problem I'm having is that the error is still displaying when I try to add new items (specifically using datasheet edit view) where the field is blank. Is there a problem with my formula?

1 Answer 1


Working forumla:

=IF(AND(NOT(ISBLANK([My Text Field])),NOT(LEN([My Text Field])=3)),FALSE,TRUE)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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