Jul 18, 2018 12:30 AM
Hi
I would like to count the number of events within a period. The setup is as follows:
Table “Matches” with fields “team (referenced to “Teams” table)”, “kickoff (date day&time)”
Table “Teams” --> new formula field to count number of matches in a specific season/period on “Matches”
Is it possible to create such a formula without the COUNTIF function?
Thanks in advance for your support, Chris
Jul 18, 2018 08:39 AM
hi Chris,
I would create the time periods on “matches” like this:
IF(AND(kickoff>="2018-07-01",kickoff<="2018-07-31"), kickoff)
and then, on Teams, I will use rollup field with COUNTA formula to count them.
something like this base
https://airtable.com/shr1tXBmNYuNmQrr7
Jul 20, 2018 03:29 AM
hi Ilan, that’s a great idea, works perfectly… …until COUNTIF is available.
Thanks :grinning_face_with_big_eyes: