Help

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

Topic Labels: Formulas
Solved
Jump to Solution
125 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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?

1 Solution

Accepted Solutions

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.

See Solution in Thread

2 Replies 2

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.

Hey kuovonne! This was the solution to my problem!

Thanks for your help :slightly_smiling_face: