Help

Issues with Groups not Grouping Identical Content

1999 12
cancel
Showing results for 
Search instead for 
Did you mean: 
Peter_Kassel
4 - Data Explorer
4 - Data Explorer

Hello! I have been organizing the content of my company’s information for a few weeks and got to the point where I could set up a customer table from my list. When I choose what information is going to be present, and then group the information, even though the essential groupings are identical, Airtable is breaking the information up. You can see the attached screenshot (with names redacted) for an example.

Customer Relationship and Market Sector are the items that I am grouping by and this is what happens:

Screen Shot 2021-04-20 at 3.28.48 PM

Is there some sort of metadata that could be causing this issue?

12 Replies 12

Try
ARRAYCOMPACT(ARRAYUNIQUE(values))
or
ARRAYUNIQUE(ARRAYCOMPACT(values))

The first formula having been applied to both Market Sector and Relationship has worked! Thank you very much!

Great! For reference, ARRAYCOMPACT() removes white space or “empty” values returned in a Rollup.