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?

  • What error are you getting?
    – Geeky Guy
    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")

  • This does not answer the OP's question.
    – Geeky Guy
    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.
    – Geeky Guy
    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 clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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