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

Conditional rollups

Topic Labels: Base design
310 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Is it possible to do a conditional rollup where it looks for just records this month rather than in the last 30 days? Or do I have to set up the formula with after July 1 and before July 31?

1 Reply 1

In the table that’s the target of your rollup, add a formula field with the following formula (changing {Date} to the field containing the date you want to compare against):

MONTH(Date) = MONTH(NOW())

That will return a 0 or 1 if the date is in the current month. In your rollup condition, have it grab records where that field’s output is 1.