Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Count rows within a date range and a criteria

318 1
Showing results for 
Search instead for 
Did you mean: 

Hi all! Thanks in advance for any advice or help!

We’ve got the following situation:

  • We have a table with a Date field, so each entry has a date
  • Each entry also has a checkbox field (so checked or unchecked)

We would like to do the following:

  • In another table, for each week get a sum of the number of entries in the other table that (a) occured during that week, and (b) have the checkbox checked

Does anyone know how to do this? We’ve been playing with roll-ups and counts but we can’t seem to find a solution that doesn’t require linking to every entry in the table…

Thank you!

1 Reply 1

Hi @Darin_Bellisario

Is it an option to simply add a formula field with WEEKNUM() to get the week number from your date field and then group on that formula field to get the numbers of record in that week? You could add a view that only show the “checked” records.