
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 03, 2023 03:16 PM
Hey Everyone,
Trying to create a formula that counts how many records in a date field are todays date, let me know if you know how to do this.
I am totally fine if let's say there are 10 records and 4 of them are todays date and the formula counting the ones with todays date just says "4" next to all of the ones that are today - I don't need it to be like chronological as in the first one saying "1" the second one saying "2", etc.
Thank you for any help, greatly appreciate it!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 03, 2023 03:30 PM
In Airtable, a formula field cannot reference other records. So you cannot do this in a formula field.
However, you can create a filtered view that shows only records for the current day, and then you can look at the record count in the summary bar.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 04, 2023 03:26 AM
If you needed to access that number for automations, reports, etc, you could also try doing this by linking all your records to a single record in another table and using a conditional Count field
