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

List of Unique values from a RollUp and Count of times used against each (Unique Value: Count)

Topic Labels: Formulas
376 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi there. I am working with a Rollup up field linking between a Series table and ID table. The ID table has a field called Episodes. What I am trying to work out is how do I display the number of episodes linked from the linked ID table and the count of each.

Example:
Episode Roll Up
9, 5, 3, 3
(so there are four ID records linked to the Series table and from the ID table’s Episode field there is 1 x ID from Ep 9, 1 x ID from Ep 5 and 2 x IDs from Ep 3)

What I would like to display either directly in the RollUp field or in a companion Calculation field is the following:
3: 2
5: 1
9: 1
(so I’d like to be able to order the Episode numbers as well to make it cleaner to view).

I have searched thru the Community posts but can’t find anything that addresses this particular query. Any help would be very much appreciated!

0 Replies 0