Skip to main content

I am in the process of changing everything from excel/sheets over to Airtable and I have run into a strange problem that is quite trivial in Excel/Sheets but seemingly difficult in Airtable.


Essentially all I want to do is count how many times an email address has come up in the last 30 days from a DATETIME.


Each record has a unique datetime and an email address, all I’m trying to do is count how many times that is happening in Airtable.


The function in sheets is =COUNTIFS(A:A,A2919,B:B,">="B2919-30,B:B,"<="B2919))


Where A is the email column, and B is the date of entry.


Any help would be appreciated.

You might be able to use the summary bar for your needs.


I’d create a new view where records are grouped by the email field (Field A). Field B remains your date field. Then create a formula field (Field C) where the formula is something like DATETIME_DIFF({Field B},TODAY(),'days').


Create a filter for this view: Where {Field C} ≥ â-30] AND Where {Field C} ≤ }0]


The summary bar will count how many times the email was used in the last 30 days.

Terms & Conditions