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!
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.
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.