Contains formula question

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

Datasets

Accepted answers

Luke_C

Hi @Jake5

Here's one way:

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

New Workflow3.yxmd

All comments

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!

Contains formula question.yxmd

Luke_C

Hi @Jake5

Here's one way:

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

New Workflow3.yxmd

Jake5

Thank you both!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335