Jun 23, 2024 02:33 AM
Hi,
Let's say I have a People table with Name A, Name B, Name C.
Another Table "Sports", which links Name A with Football, Name A with Football (again), Name A with Basketball, Name B with Basketball, Name B with Basketball, etc.
In the People table I want to create a (rollup?) field that returns e.g. for Name A: "Football (2), Basketball (1)" as a string.
Haven't been able to figure it out playing with COUNT, ARRAY, etc in Rollup field and searching this forum. Any ideas?
Jun 23, 2024 05:52 AM
You cannot do this with only a single rollup field with the current Airtable features.
If there are only a few possible sports, you could have a conditional rollup field for each sport, then combine the info for all the sports using another formula field.
Jun 23, 2024 06:55 AM
If you have defined list of sports, you can hardcode them in formula
IF(Find('SPORT', {Rollup}),
'SPORT: '&(LEN({Rollup})-LEN(SUBSTITUTE({Rollup}, 'SPORT','')))/LEN('SPORT')
) &
IF(Find....
repeating it X times with the name of sport instead of SPORT
{Rollup} is rollup field, with all linked sports.