Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Jan 03, 2022 03:10 PM
Hi There,
I am responsible for reporting the number of open projects per month that my team works on and breaks it down into four project categories. I am trying to build a Base that does the following:
I have built point 1 + 2 without issue, but I am having trouble with point 3. Any help would be appreciated.
Best,
Colin
Jan 04, 2022 12:59 AM
Hi Colin,
risking that I haven’t completely understood what you’re in need for:
My first guess would be that you want to use the count field with a condition. That condition would be a month. In order to get the month, you need to apply the Month() formula on a date field (otherwise with the given Airtable filters currently, you would need a start and an end date). You then apply the count condition (like a CountIF in Excel then) to match only those in a particular month. You could use another condition on the count field for the categories.
Hope that helps!
Rupert