In this example, I would like to validate the length of the ID number as well as that it only contains numbers. Of course if it must be numbers, just use a number column, but if it’s meant for ID, Reference or other type of numbers then this works great! Change formula to validate the length you need = for example employee number – only 6 digits and only numbers. This is also available in SharePoint on-premises versions.


=IF(LEN([Identity Number])=13,ISNUMBER([Identity Number]+0),FALSE)

or you can use:

=AND(LEN([Identity Number])=13,ISNUMBER([Identity Number]+0))

Purpose of this blog challenge:  I will write 365 blogs in 365 days around Microsoft 365. I did a similar challenge with Office 365, blogs can be found . I won’t just be talking about the new Microsoft 365 subscription model. I will be sharing any news, tips and tricks around Office / Office 365 / Windows / Mobility and Security. And let’s not forget all the great new Apps & services available.  A lot of what I’ll share on Office and SharePoint will also be applicable to none “Office 365” versions.

“You can also find me contributing to REgarding 365. I’m a member of a group of enthusiasts, sharing their stories, thoughts and opinions about Microsoft 365. Catch us at | @regarding365 on Twitter and regarding365 on YouTube

Disclaimer:  I create content about Office / Microsoft 365. Content is accurate at time of publication, however updates and new additions happen daily which could change the accuracy or relevance. Please keep this in mind when using my blogs as guidelines.