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

Question

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 Answer

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 formatIF(    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 · Answer

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 formatIF(    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! 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:

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded