ARRAYUNIQUE not working in formulas for lookup fields

[redndahead]

I have a database that looks like this:

In the Unique formula field I have a formula that looks like this:

ARRAYUNIQUE({Projects})

As you can see it returns an empty result. I actually believe it’s silently erroring out, because if I change the formula to “Blah” it will return:

Blah

If I then change the formula back to:

ARRAYUNIQUE({Projects})

Then it will still display “Blah”.

[Chris]

I could replicate redndahead’s problem exactly as he shows it and can add the following:

1. If I change the formula to any other formula it continues to displays the results of that formula after I change it back to ARRAYUNIQUE (see screenshot where the formula is ARRAYUNIQUE but it show the result of a previous ARRAYJOIN
2. The other array functions ARRAYCOMPACT, ARRAYFLATTEN, show the same behaivour as ARRAYUNIQUE

[redndahead]

I think the switching from ARRAYJOIN to ARRAYUNIQUE demonstrates the same thing I was saying above about “Blah”. Those functions work so it’s displaying a value, but the ARRAYUNIQUE fails silently so it leaves the last value that worked.

Thanks for validating it though.