1

I have a SharePoint list with Column Status and Impact. I need to validate If Status equals "Pending" or "Approved", then Impact can NOT equal "U". At this point I want the users to change their choice for Impact to "Y" or "N" otherwise they can not save.

Column (dropdown) Name:

Status - New, Pending, Pending Assessment, Approved

Impact - U, Y, N

I've attempted the following Formulas: but they don't seem to work correctly

=IF([Status]="Approved" or "Pending Assessment",AND(NOT([Impact]="U")),FALSE)

=OR([Status]="Approved" , [Status]="Pending Assessment"),AND([Impact]="U"),FALSE)

=IF(ISNUMBER(FIND("Approved",[Status])),AND(NOT([Impact]="U")),FALSE)
0

Try below formula:

=IF(OR([Status]="Approved", [Status]="Pending"),IF([Impact]="U",false, true), true) 

Update from comments:

=IF(OR([Processing State of CS]="Approved for Implementation",[Processing State of CS]="Approved for Assessment"),IF(OR([CAT Impact]="U",[SEC 31 Fee]="U"),FALSE,TRUE),TRUE)
| improve this answer | |
  • Awesome! That worked! The requirements were updated and now I need to add a second validation - In column "Section" it can not be equal to "U" the same as in "Impact" - I expected this to be a straight forward edit but I'm NOT able to get work. This is the updated formula - =IF(OR([Processing State of CS]="Approved for Implementation",[Processing State of CS]="Approved for Assessment"),IF(OR([CAT Impact]="U",[SEC 31 Fee]="U",FALSE,TRUE),FALSE,TRUE)) – Melissa C Jan 29 at 19:41
  • Try updated formula from my answer. It should work for you. – Ganesh Sanap Jan 30 at 2:37
  • 1
    Thank you so much for your help! I Greatly Appreciated – Melissa C Jan 31 at 16:26

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.