Help with an ISNOTBLANK Expression

[cjphoto]

Hey there. I need help with an expression. Here's what I'm trying to accomplish. If NAME 1 is not blank and the CONDITION is set to either 'No contact info available' or 'Vacant' then set the CONDITION as blank (""), otherwise keep it the same ([CONDITION]).

This is the expression that I tried but I'm missing something. Would appreciate any help please. Thank you!

IF(
AND(
ISNOTBLANK([NAME 1]),
INTERSECT(
LIST([CONDITION]),
LIST('No contact info available', 'vacant')
)
),
"", [CONDITION]
)

Also the expression will be applied to an action.

 

[Marc_Dillon · Accepted solution]

INTERSECT is not what you want. That returns a List, you need to return a true/false value there. Check out IN()

https://help.appsheet.com/en/articles/2357277-in

[cjphoto]

Awesome!!! Changing INTERSECT to IN did it!

Thank you very much Marc!

IF(
AND(
ISNOTBLANK([NAME 1]),
IN(
LIST([CONDITION]),
LIST('No contact info available', 'vacant')
)
),
"", [CONDITION]
)