How do you show_if with a positive conditiona...

(Zachary Gatch) #1

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 KULAÇOĞLU) #2

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

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


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

(Aleksi Alkio) #3

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

(Zachary Gatch) #4

Thank you @Aleksi_Alkio @Levent_KULACOGLU!

I greatly appreciate your help and guidance.

(Aleksi Alkio) #5

You’re welcome