+9Hey 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!
+29In 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.
+31If 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.