0

I need help with a validation formula in a SharePoint Text column where:

  • column can be empty ( the default state when list is opened)
  • column can be null (the state after a value is deleted)
  • must be all numbers
  • must be 8 digits long

My unsuccessful try:

=OR(ISBLANK(FCN]),(FCN]=""),""),AND(LEN([FCN])=8,ISNUMBER([FCN]+0)))

Thank you!

1 Answer 1

1

Try using this formula:

=OR(ISBLANK([FCN]),[FCN]="",AND(ISNUMBER([FCN]),LEN([FCN])=8))

OR:

=OR(ISBLANK([FCN]),[FCN]="",AND(ISNUMBER([FCN]+0),LEN([FCN])=8))

Note:

  1. Sometimes comma(,) does not work in formula (it is based on language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).
  2. Use correct display name of your SharePoint columns in above formula.
  3. Wrap column names inside [] if your column name has space in it. For example: [My Column Name].

Official Documentations:

  1. Calculated Field Formulas
1
  • 1
    Ganesh! #2 did the trick. Thank you very much for all your steady help! Cheers-
    – ChasEpes
    Jul 20, 2023 at 13:04

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.