1

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?

  • is this an excel conditional formula? – Ali Jafer Mar 21 '13 at 17:03
  • This is a validation formula for Sharepoint column 2010. – user15805 Mar 21 '13 at 17:12
  • 1
    Unfortunately you cannot use other columns in a column validation formula – Kirk Aug 9 '13 at 18:28
1
=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.

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.