Count unique values in a column

[Steve_Doll]

Hi all,

When grouping, Airtable automatically does this count, anybody know if we can pull this Count Value into a cell with like a Formula or something?

[ScottWorld · Accepted solution]

Unfortunately, the values in the summary bar are completely inaccessible to us in formulas. :frowning:

You can only get a count by counting linked records in another table. So, if your records are linked to another table, then you can do a count from that other table — and you can even re-lookup the count back into the current table.

Otherwise, you’d need to create your own custom JavaScript that loops through the records and figures out the count of each group — and then stores the count of each group somewhere.

This sort of group counting can also be created with Integromat’s aggregator module, which is a low-code/no-code platform that lets you do many of the advanced things that you would normally need JavaScript to do.

[Steve_Doll]

Thanks for the reply, much appreciated.