Linked Records - See field Data in linked record f...

[Michael_Benson]

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.,

Any help would be much appreciated!

Cheers

[kuovonne]

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()