Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Compare Linked Record field against Rollup field

Topic Labels: Formulas
722 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Michael_Benson
6 - Interface Innovator
6 - Interface Innovator

Hello,

I want to compare the values of a Rollup field with a Linked Record field.

Field A is a rollup that contains the following text:

"Value 1, Value 2"

Field B is a Linked Record that contains the following records:

Value 1 Value 2

I want a formula that will check if the two fields are the same. At the moment Airtable is failing whenever a comma is included in Field A. 

e.g.,

Michael_Benson_0-1683930356490.png

Any help would be much appreciated!

Cheers

1 Reply 1

Is the rollup based on the linked record field or something else? If it is based on the linked record field, there is no need to do a comparison. 

If it is based on something else, you can use another rollup based on the linked record field to introduce the comma with ARRAYJOIN()