How do you show_if with a positive conditiona...

How do you show_if with a positive conditional statement and a negative conditional statement.

I thought this would work, but it’s a fail:

AND(CONTAINS([Enter call report?],“Yes”,NOT([Account affiliation?],“Menards”))

This is the error I get:

Condition NOT([Account affiliation?]) has an invalid structure: no more than 1 subexpression(s) allowed

Any thoughts on how to write this so I get a green check mark!?!?!

0 4 366
4 REPLIES 4
Top Labels in this Space