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 number of records based on the date

Topic Labels: Formulas
1003 3
Showing results for 
Search instead for 
Did you mean: 

Hey there,

I have a table where all the leads are automatically copied to fields. I’d like to count how many leads/calls/sales I have made based on the date.

Can anyone help me with that?

3 Replies 3

Hi @avto_kolashvili,

Welcome to Airtable Community!

To count records, you can use the Rollup function, CountA(value)


I’ll try to explain more specifically.

On Table 1 I have list of leads with:

  1. Status field (single select) where there are several options: Done, In Transit, Submitted…
  2. Quantity field - It shows how many items was requested in lead
  3. Date created field - it shows date when the record was created.

My goal is to create a new table, where I can count leads based on the status (Done or blank) and date. for instance

Date - 12 April
Leads - (show number of records for 12 April with any status)
Sales - (show number of records for 12 April with Done status)

Since you want to do it by date, then you need to use the chart block.