IF contains

[harithad1]

Hi, 

Need help with the expression to be used to get the result column. If check 1 & Check 2 contains "Pass", then the result should be true otherwise false.

Check 1	Check 2	Result
Validation check : Pass	Validation check : Fail	FALSE
Validation check : Pass	Validation check : Pass	TRUE
Validation check : Fail	Validation check : Pass	FALSE
Validation check : Fail	Validation check : Fail	FALSE

[PhilipMannering]

endswith([Check 1], 'Pass') and endswith([Check 2], 'Pass')

[harithad1]

@PhilipMannering Thanks for this.

But what if the column 1 and 2 are not ending with Pass or Fail but with some other word. Lets say " Validation check : Pass customer". In this case, what expression can be used?

[Mathias_Nielsen · Accepted solution]

HI @harithad1 ,

This will look for "pass" anywhere in the two check columns and only return "TRUE" if it exsists in both columns.

if Contains([Check 1], "pass") and Contains([Check 2], "pass") then "TRUE" else "FALSE" endif

Hope this works for you :)

[harithad1]

That worked, thank you @Mathias_Nielsen