If a value exist on rows, then it should pass

h12

Hi all

I have this data set

A	B	B1	C	D	D4	I WOULD LIKE TO CREATE THIS COLUMN: Pass/Fail
No match	3	xx	4	No Match	yy	Fail
2	Data Issues	xx	Data Issues	Data Issues	yy	Fail
Data Issues	Data Issues	xx	Data Issues	Data Issues	yy	Fail
2	4	xx	5	6	yy	Pass

I would like to create a pass or fail column which says... if the column has data issues or no match then flag as a fail. There will be multiple columns between the A B C D columns flagged above but I only want to check these.

Many thanks!

atcodedog05

Hi @h12 

You can use formula like below.

IF [A] in ("No match","Data Issues") 
or [B] in ("No match","Data Issues") 
or [C] in ("No match","Data Issues") 
or [D] in ("No match","Data Issues") 
THEN "Fail" ELSE "Pass" ENDIF

Workflow:

Hope this helps : )

No Match.yxmd