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 have three columns, "Status", "Request Date" and "Completion Date". I want to do two things:

  1. If "Status" is Closed or Withdrawn, I need to add validation to have the user enter a completion date if the completion date field is blank.
  2. The Completion date needs to be equal to or greater than the request date.

Any help on this validation formula is appreciated.

share|improve this question
Are you doing this in InfoPath? If not, I think that's the only way you'll be able to do this. Don't quote me though, I know nothing about InfoPath :P – James Love Apr 5 '11 at 20:00

You can accomplish half of this through the UI, the other half you have to do either through an event reciever or JavaScript.

For the second requirement, no problem. Just use column validation to do this.

For the first requirement you can't change the required/optional status of a column on the fly with the bulit in validation features of 2010. However it is easy to write an event receiver to handle this in the ItemUpdating method and fail the update if the field isn't filled in.

It's possible to do the first requirement with JavaScript but it's hard to stop SharePoint from saving items and finishing it's cycle (possible, but I would look at an event receiver first).

share|improve this answer

Your Answer


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