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:
MAX(values)
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 … 
1 Like
That’s great to hear! Glad it worked! 