Below you will find pages that utilize the taxonomy term “AccountNumbeSortCode”
posts
Column Validation for Sort Code and Account Number in SharePoint
Column Validation for Sort Code and Account Number in SharePoint Column validation provides a solution to validate data for data integrity. This post covers column validation for Sort Code and Account Number in SharePoint.
Validation for Sort Code =AND(LEN([Sort Code])=6,ISNUMBER([Sort Code]+0))
The above formula checks
The length of the sort code must be exactly 6 digits. The sort code must be a number. Validation for Account Number =AND(LEN([Account Number])=8,ISNUMBER([Account Number]+0))