Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.