Formula Issue (AND, OR, not contain)

[Srinivas_Alteryx]

Hi All,

could you please validate the below formula and let me know what changes are required to get a complete result.

IF [Position Status]== "Open" 

AND 

([Candidate Search Type]!= "Internal"

OR 

!(Contains([Position Restriction Job Posting Title],"Internal"))

OR

!(Contains([Position Restriction Job Posting Title],"Internal"))) 

THEN 1 ELSE 0 ENDIF

[CoG]

There is nothing wrong with your formula. What is your desired behavior and what is the error that you are addressing?

The duplicated Contains function is redundant and doesn't accomplish anything for you currently.

[aatalai]

@Srinivas_Alteryx possibly try only one equal sign in the first line?

IF [Position Status]= "Open"

as opposed to   IF [Position Status]== "Open" 

Otherwise I agree with @CoG 

[Naresh7855]

Thanks for allowing us to Post