Roll up to derive the latest edit in Rich Text field

I am a newbie , for some reason I a unable to get the roll up formula to work for me , screen shot attached for reference… what am I doing wrong here?

Thanks guys … keep rolling out "Built on Air " podcasts, I am trying to catch up !!

Welcome to the community, @Phantom!

If you want to get the maximum of the field you’re pointing to, the rollup formula would be:


However, note that you can only get the MAX of a number or a date, not a text field.

Thanks for the prompt response Scott… could you guide please guide me how to go about looking up the last edited entry in the field(text field), I tried the conditional lookup with time , can’t figure out the way to filter the last edited entry …

Sadly, Airtable doesn’t offer the ability to do that in any easy way.

You would need to use the trick that I describe in this episode of the BuiltOnAir podcast:

1 Like

Hey Scott ,

This simply worked !! wish I had connected earlier … :smiley:

1 Like

That’s great to hear! Glad it worked! :smiley: :raised_hands: