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!?!?!
User | Count |
---|---|
35 | |
34 | |
26 | |
23 | |
18 |