I have been struggling with a project recently. I am trying to basically take a list of names or emails from two separate Rollup fields and combine them, removing the duplicates. However, Airtable seems to be having trouble combining ARRAYJOIN(), ARRAYFLATTEN(), or ARRAYUNIQUE() in any way that works for me.
So far, my only solution was to use some nested IF statements and concatenation to force it to work to an extent, but the fields get messed up if both columns I am pulling from are not blank.
I have tried a couple of different suggestions from other posts, but I would appreciate if someone could point me in a good direction.
Basically I have two rollup fields that looks for ARRAYUNIQUE(values) for some emails or names from another table. What I am looking for is to take those two and merge them into a single list of those unique emails, hopefully with each any duplicates between both removed.