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?
Count number of records based on the date
+17Hi @avto_kolashvili,
Welcome to Airtable Community!
To count records, you can use the Rollup function, CountA(value)
BR,
Mo
Hi @avto_kolashvili,
Welcome to Airtable Community!
To count records, you can use the Rollup function, CountA(value)
BR,
Mo
I’ll try to explain more specifically.
On Table 1 I have list of leads with:
- Status field (single select) where there are several options: Done, In Transit, Submitted…
- Quantity field - It shows how many items was requested in lead
- 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)
+17I’ll try to explain more specifically.
On Table 1 I have list of leads with:
- Status field (single select) where there are several options: Done, In Transit, Submitted…
- Quantity field - It shows how many items was requested in lead
- 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.