Thursday, March 18, 2010

List Validation

You can only compare column values to one another in a list level validation.

A validation formula at the column level cannot include any other columns besides itself.  For example, [Column1]>[Column2] is an invalid formula and SharePoint will not allow it to be used at the column level.

image

image

=AND([Paper 1],[Paper 2],[Paper 3],[Paper 4],[Paper 5]<=100,[Paper 1],[Paper 2],[Paper 3],[Paper 4],[Paper 5]>0)

image

Limitations

1. What if you have both column level validation and list level validation?
The column level formulas will be evaluated first, then the list formulas

2. What if the column and list level validations are in conflict?
Example - at the list level, you require that [Text1] = [Text2],
but each column has it's own validation; [Text1]="AAA", and [Text2]="BBB". 
In this case, it will be impossible to actually submit a list item. 

3. The column validations are evaluated first, but if the values validate here, they will of course fail the list validation.

No comments: