Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Match record contained in two fields

1175 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Michael_Harriso
5 - Automation Enthusiast
5 - Automation Enthusiast

I’m looking for a way to pull the matching record in two fields.

I’m pulling a bill of materials in from our product table so for example it will pull in these records;
8" Black rod
6" Black Shade
10" Box

In another field I’m pulling in all the parts that match a certain attribute for example
6" Red Shade
10" Red Shade
6" Black Shade
10" Black Shade
6" Green Shade
10" Green Shade

I’m trying to create a field that will see that in the example above the 6" black shade is in both of those fields and return that record.

1 Reply 1

Hi @Michael_Harrison,

Just to understand better, both will be in the same record (row)?

If so, you can make a formula in a new field that is something like IF(field1=field2, Field1, 0)