Rollup aggregation formula to grab most recent checkbox status

[Rasha]

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!

[ScottWorld]

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

[Rasha]

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.