Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Rollups using ARRAYCOMPACT and ARRAYUNIQUE don't wrap in tall rows

Topic Labels: Formulas
1016 3
cancel
Showing results for 
Search instead for 
Did you mean: 

Rollups using ARRAYJOIN will wrap in a Medium, Tall, or Extra Tall cell, but those with ARRAYCOMPACT and ARRAYUNIQUE get truncated. I would think this is not the desired behavior.

3 Replies 3

Note that ARRAYJOIN() returns a text string, while ARRAYCOMPACT() and ARRAYUNIQUE() return arrays. Try appending ‘&''’ (that is, the ampersand character followed by an empty string) to either of the last two functions to cast the response into a string; I expect they will then wrap.

Ahhh…great catch. I should have RTFM a little closer and caught that ARRAYCOMPACT and ARRAYUNIQUE returned arrays. Thanks!

I think it’s something you more need to intuit than read. :winking_face:

Actually, it is in there, but very subtly indicated.