SharePoint Validation: If Empty or Null

Question

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

My unsuccessful try:

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

Thank you!

Ganesh Sanap - MVP · Accepted Answer · 2023-07-20 05:51:08Z

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:

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(,).
Use correct display name of your SharePoint columns in above formula.
Wrap column names inside [] if your column name has space in it. For example: [My Column Name].

Official Documentations:

answered Jul 20, 2023 at 5:51

47.4k22 gold badges32 silver badges64 bronze badges

1 Answer 1