I am trying to add validation for my share point lists. I have List with items containing some fields [Delete Item] ,[Scored Status] and some other. I want if the item is scored than user should not be allowed to select the check box for field [Delete Item]. So I am using following formula for same but it doesn't work:

=IF([Delete Item]="Yes",
IF([Scored Status]="Scored", FALSE, TRUE),TRUE)
  • Thanks it worked. – SapChad Apr 2 '19 at 17:49

Add the validation formula to the List Validation, not the Column Validation.

List/Library Settings, List Validation

If the [Delete Item] column is a Yes/No then try this:

=IF( [Delete Item],
 IF( [Scored Status]="Scored", FALSE, TRUE), TRUE)

And you should be able to shorten the above to:

=NOT( AND( [Delete Item], [Scored Status]="Scored" ) )
| improve this answer | |
  • Thanks it helped. – SapChad Apr 2 '19 at 17:46

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.