Summarizing data

I’m trying to summarize date data from 3 different columns:

I want to summarize it based on the month of the year so it will look like this:

When I was using Google sheets I would have simply used the “countifs” formula and that counted dates based on the month & year formulas

Since there is no countifs in Airtable I can’t figure it out either via a formula or either via pivot table

Check if the pivot table block does what you need!

Pivot table block can’t be used for more than one column, I have 3 columns

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.