Contains formula question

[Jake5]

Hello.  As depicted in the table below, I'm trying to write a formula where if '2' is found within any of Field Value A, then ALL records in Field Value B will display 'ABC'.  Any suggestions for how to accomplish this?  Thank you. 

Field Value A	Field Value B
1	ABC
2	ABC
1	ABC
1	ABC

[alexm06]

Hi @Jake5 ,

I've attached a workflow that might solve this problem for you. Basically using the summarize tool to apply logic if there are any instances of "2" in the Field Value A column

Please let me know if that solves it!

[Luke_C · Accepted solution]

Hi @Jake5 

Here's one way:

1. Filter on Column A = 2
2. Count the records from the true anchor
3. Append the count to the dataset
4. If the count >=1 then set field B to 'ABC'

[Jake5]

Thank you both!