Hopefully someone can help with composing a formula for a validation of a column in a sp list.

I've have 3 columns with the choice "pending" or "completed". The validation would take place on the 3rd column as it never can be completed if one of the 2's status is still pending.

Hope someone could help

1 Answer 1


say you have fields f1, f2, f3 - F3 can be completed only if f1 AND f2 are completed. all three are choice fields with pending or completed as valid values. got to list settings - then in 'item validation' - put the following =OR( AND(OR([@F1]="Pending", [@F2]="Pending"), [@F3]="Pending"), AND([@F1]="Complete", [@F2]="Complete", [@F3]="Complete") ) this is directly from excel (the best way to experiment with these things). Plreace @F1 with F1, etc. Note - this returns false if the two are pending and f3 is not complete but that would be easy to fix.

This returns the following (f1, f2, f3

Pending Pending Pending TRUE Pending Complete Pending TRUE Complete Pending Pending TRUE Complete Complete Pending FALSE

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.