Formula Issue (AND, OR, not contain)

Question

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

Naresh7855 · Answer

Thanks for allowing us to Post

aatalai · Answer

@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

CoG · Answer

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.