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

Rollup aggregation formula to grab most recent checkbox status

Topic Labels: Formulas
162 2
Showing results for 
Search instead for 
Did you mean: 

In an Interactions table, I’m using a checkbox field to mark specific interactions 7-day follow-up. In a different table, I’d like to see if the most recent interaction for a contact has 7-day follow-up checked. MAX(values) works for dates but returns zero here.

Thanks for the help!


2 Replies 2

That’s a little tricky to do in Airtable. I describe how to do something extremely similar in this episode of the BuiltOnAir podcast:

Holy… Thanks for sharing this! I’m accustomed to resorting to an equally painful workaround on a different platform but didn’t expext this here. I’d absolyely go fo it but… bloat.