Tuesday, September 13, 2016

Simple SharePoint List Item Validation Example

Sometimes SharePoint validation can be touchy. This is a simple example of ...

If you answer "Yes" then you must also complete this other field.

VPN is a choice field. VPN Justification is a single line of text.

The formula is:

=IF(VPN="Yes",LEN([VPN Justifiction])>2,TRUE)

and the User Message is:

VPN justification must be completed

Simple and effective.