Rollup aggregation formula to grab most recent checkbox status

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!

image

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

1 Like

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.

1 Like

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.