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?
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.
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.