Help

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

Solved
Jump to Solution
1330 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Dismal_Reindeer
5 - Automation Enthusiast
5 - Automation Enthusiast

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
kuovonne
18 - Pluto
18 - Pluto

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
kuovonne
18 - Pluto
18 - Pluto

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: