Compare Linked Record field against Rollup field

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

Page 1 / 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()

Sign up