Skip to main content

Count events in a period

  • July 18, 2018
  • 2 replies
  • 20 views
C

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

    This topic has been closed for replies.

    2 replies

    I
    Forum|alt.badge.img+7
    • Ilan_Ben_Yaakov
    • Participating Frequently
    • July 18, 2018

    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

    C

    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


    hi Ilan, that’s a great idea, works perfectly… …until COUNTIF is available.

    Thanks :grinning_face_with_big_eyes:

      Terms & ConditionsAccessibility statement