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?
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.
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 
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.