Extract highest number from an array...

[Aaron_Hess]

I've got records of song names.  I have a field with the dates we've played the song.  I want another field to extract the most recent date the song was played, but don't know how to get there.  How do I extract the highest number from an array?  Seems like it should be a simple MAX() command, but that doesn't work.

[TheTimeSavingCo · Accepted solution]

Hm, I was able to get this work like so:

Here's a link to the base if you'd like to check it out

[Aaron_Hess]

Thank you!  Apparently I don't have a solid handle on how roll ups work yet.  This solved my problem

[Aaron_Hess]

Can I post a followup question?  Can I use a rollup with a formula to find how many times I've played a song in the last 3 months? 

[TheTimeSavingCo · Accepted solution]

Ah you wouldn't need a rollup for that, you could just use a count field like so:

And I've updated the base I linked above to have it as well

[Aaron_Hess]

Bam! awesome thank you!  Not sure if I'm more literate in Airtable, therefore this forum is more useful; OR if the community is growing but I've gotten a lot more useful response on here