Using the Custom Filter to filter out multiple criteria

[JeniferReid1]

I would like to update the formula below to include any records where the Job Title is "Director" in addition to the "Manager" job title which is included below. I am not sure what the correct syntax would be to include the "Director".

IF

contains([Job Family Group],"Sales")
AND
contains([Job Title],"Manager")

THEN 'false'
ELSE 'true' ENDIF

[Emil_Kos]

Hi,

you can try:

IF

contains([Job Family Group],"Sales")
AND
contains([Job Title],"Manager") OR contains([Job Title],"Director")

THEN 'false'
ELSE 'true' ENDIF

there is also formula IN but i dont have access to Alteryx now to Check it. 
with it you could replace this part:

 contains([Job Title],"Manager") OR contains([Job Title],"Director")

[Qiu · Accepted solution]

@JeniferReid1 

Sample workflow based on the idea of @Emil_Kos 

[JeniferReid1]

Thank you - that worked!