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 · Accepted solution]

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 : )

[h12]

Oh yeah, sorry I m not sure why I was thinking I need the multi row formula tool! I have a large data set of over a million rows, I assume the above would work for that as well?

[atcodedog05]

Hi @h12 ,

Yes it should work.

[h12]

Thanks!