Skip to main content

Rollup aggregation formula to grab most recent checkbox status

  • September 9, 2022
  • 2 replies
  • 20 views

Forum|alt.badge.img+9

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

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • September 9, 2022

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


Forum|alt.badge.img+9
  • Author
  • Known Participant
  • September 9, 2022

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.