SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I would like to validate a list item so that if one field is true, then another must be completed. If the first one is false, then it can be ignored.

=(([Start Deferment]="Specific Date") AND [Start Deferment Date] > TODAY()) OR ([Start Deferment]="Next Payment")

This gives an error, so I am guessing my syntax is incorrect?

share|improve this question
What error are you getting? – Renan Jun 12 '13 at 12:31

It appears the validation formulae are similar to Excel:

=OR(AND([Start Deferment]="Specific Date",[Start Deferment Date]>TODAY()),[Start Deferment]="Next Payment")

share|improve this answer
This does not answer the OP's question. – Renan Jun 12 '13 at 12:32
Yes it does...i was the OP and this is what solved it? – BlueChippy Jun 17 '13 at 4:49
My bad, I was trying your solution and getting a syntax error myself due to a typo of mine. – Renan Jun 17 '13 at 11:41
no worries..had a 'mare getting these right myself :( – BlueChippy Jun 17 '13 at 18:00

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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