NOT() with multiple criteria?

I’m trying to make an action button not appear under two conditions. I can do this for one condition, but can’t figure out the syntax for two conditions. It seems like it should be straightforward, but after spending a bunch of time trolling the boards and reading up on NOT(), OR(), AND(), SELECT(), etc, I just can’t make it work. This expression does what I want for one condition:

I basically want to add another item to that list called “PNP”, so the action button wouldn’t appear for PSA or PNP. Both are in SHORT NAME.

Thanks for any assistance for this newbie.

Solved Solved
0 3 276
1 ACCEPTED SOLUTION

Thank you, @Suvrutt_Gurjar ! I added NOT in front of the expression and it worked perfectly (see below). I really appreciate your help. I learned several new things from examining your expression.

NOT(OR([SHORT NAME]<>“PSA”,[SHORT NAME]<>“PNP”))

View solution in original post

3 REPLIES 3
Top Labels in this Space