Help

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

Counting but not merging duplicates

Topic Labels: Formulas
660 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

1 Reply 1

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.