How do you show_if with a positive conditiona...

[Zachary_Gatch1]

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!?!?!

[Levent_KULACOGL]

@Zachary_Gatch1 Your syntax is not correct. It shall be:

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

OR

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

[Aleksi_Alkio]

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

[Zachary_Gatch1]

Thank you @Aleksi_Alkio @Levent_KULACOGLU!

I greatly appreciate your help and guidance.

[Aleksi_Alkio]

You’re welcome