Formula: Get the common entities between 2 collections

Get Help
1

Is there a formula for extracting the common entities between 2 collections?

e.g

Input -
A: red, orange, blue, green
B: yellow, pink, red, blue

Desired Output -
C: red, blue

Also, the other way around

A: red, orange, blue, green
B: yellow, pink, red, blue

Desired Output -
C: yellow, pink, orange, green

2

When you say ‘collection’ do you mean multi-select options or related entities (or even something else)?

In your example, are A and B two separate entities, or are they two collections in the same entity?

3

Thanks for asking Chris! I mean related entities :slight_smile:

4

And what are A and B (and C) in your example?