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 |
Solved! Go to Solution.
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!
Hi @Jake5
Here's one way:
Thank you both!