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 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
add comment

1 Answer

=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
add comment

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.