May 01, 2018 09:12 AM
We’re planning a competition. I’ll have Attendees and Teams. Teams are made up of Attendees (two or four members per team). I want two columns on the Teams table: (1) a count of the number of checked-in members of that team and (2) a total count of members of the team.
The Attendees table will have a Checked-In field that is a Checkbox. Ideally, this would be the field that is being counted IF they are a member of the team.
May 01, 2018 09:17 AM
Well this is embarrassing but it turns out this is the default behavior of the Rollup field! :grinning_face_with_sweat: :grinning_face_with_sweat: I became confused by the UI of the field and thought it was going to count all checked-in records in the linked table and not only the linked records for that team.
May 02, 2018 02:34 PM
What is “Checked in”? You also have a Count field type: https://support.airtable.com/hc/en-us/articles/202576519-Guide-to-formula-lookup-count-and-rollup-fi...
May 02, 2018 03:07 PM
Really sorry if I’m being presumptuous but did you maybe not read my comments? :winking_face: I answered my own question in my second post and the answer to your question is in the second paragraph of my first post:
The Attendees table will have a Checked-In field that is a Checkbox.
May 02, 2018 03:17 PM
Your brain clicks in right after you press the submit button.
May 03, 2018 11:30 AM
I mean in the “real world”, just trying to figure out the best way to solve your situation.
May 03, 2018 01:18 PM
Ah OK. My apologies. Overall, my issue was solved once I realized how Rollup actually works. Also, I am using Count in another field “Total Members”. These two fields combined give me the ability to create a 3rd field (Formula) like this: “75% (3/4)”.