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 a list which has [Status] and [% Complete] as columns.

In the [% Complete] column, I added a validation rule to pass validation when [Status]="Complete" AND [% Complete]=100, otherwise retunr an error.

My formula is:

=IF(AND([Status]="Complete",[% Complete]=100), "OK", "NOT OK")

But it's generating an error, what am I missing?

share|improve this question
is this an excel conditional formula? – ali Sharepoint Mar 21 '13 at 17:03
This is a validation formula for Sharepoint column 2010. – user15805 Mar 21 '13 at 17:12
Unfortunately you cannot use other columns in a column validation formula – Kirk Aug 9 '13 at 18:28
=IF(AND(Status="Completed",[% Complete]=1),"OK","NOT OK")

This works for me. Note that 100% is 1 not 100. Also that the standard is "Completed" and not "Complete" though this will depend on whether you have customised the choices.

However, that said, I do not really see anything wrong with your formula that would cause an error.

share|improve this answer

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.