I had previously accomplished this in Google Sheets, but since moving to Airtable, I’ve had a bit of trouble replicating it.
We’re a dog training company, and want to count the number of packages that each trainer sells in a given month.
My table has a column with a date field that contains when the package is sold, a column with the trainer’s name (a linked record to a trainer’s table), and a column if the package has been paid for.
Previously in Google Sheets, I used a table that contained the date range for each month (ex. 1/1/22 to 1/31/22). The formula would see if the date the package was sold was between these dates, checked the trainer’s name matches, and if the payment contained the word “Paid”.
Would love some help trying to get this working with Airtable