Currently I have a table of leads. I would want to count the number of new leads/total leads/etc based on weekly, monthly, quarterly, etc. Or ideally even a custom date range.
Any ideas on how to implement this within AirTable?
Try using the group feature to group the records by the dates in question. (You may need to create a column that uses a formula to classify the record). When Airtable groups records, it automatically gives you a count of the records in each group and a sum of any numeric fields.
