Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Feb 13, 2019 04:13 AM
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.
Feb 13, 2019 09:07 AM
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.