Formula to search a roll up array and = true or false

[Dismal_Reindeer]

Maybe I’m just not looking in the right places but I cannot figure this out.

I have a rollup field which is outputting ARRAYUNIQUE(values) so I end up with
“Product1, Product2, Product3”

I now want to have three other formula fields which are:
“Has Product 1”
“Has Product 2”
“Has Product 3”
that will equal “True”, “False” if the the product is found in the rollup string.

How can I go about this?

[kuovonne · Accepted solution]

Welcome to the Airtable community!

Can you share a screen shot of what you’ve come up with so far?

I recommend the following:

Use the rollup formula ARRAYJOIN(ARRAYUNIQUE(values)) This will ensure that the result is a text string, and not an array.

Your other formula field can then follow the format

IF(
    FIND("Product 1", {rollup of products}),
    "Has Product 1"
)

If your product names have overlap, you might need some additional adjustments.

You can learn more about the functions available for formulas in the formula field reference.

[Dismal_Reindeer]

Hey kuovonne! This was the solution to my problem!

kuovonne:

Use the rollup formula ARRAYJOIN(ARRAYUNIQUE(values)) This will ensure that the result is a text string, and not an array.

Thanks for your help :slightly_smiling_face: