Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Extract highest number from an array...

Topic Labels: Formulas
Solved
Jump to Solution
2177 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Aaron_Hess
6 - Interface Innovator
6 - Interface Innovator

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.

Aaron_Hess_0-1678485879797.png

 

2 Solutions

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

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

Screenshot 2023-03-11 at 11.20.16 AM.png

Screenshot 2023-03-11 at 11.20.20 AM.png

 

Screenshot 2023-03-11 at 11.20.10 AM.png

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

See Solution in Thread

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

Screenshot 2023-03-14 at 1.20.05 PM.png

Screenshot 2023-03-14 at 1.20.01 PM.png

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

 

See Solution in Thread

5 Replies 5
TheTimeSavingCo
18 - Pluto
18 - Pluto

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

Screenshot 2023-03-11 at 11.20.16 AM.png

Screenshot 2023-03-11 at 11.20.20 AM.png

 

Screenshot 2023-03-11 at 11.20.10 AM.png

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

Aaron_Hess
6 - Interface Innovator
6 - Interface Innovator

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

Aaron_Hess
6 - Interface Innovator
6 - Interface Innovator

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? 

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

Screenshot 2023-03-14 at 1.20.05 PM.png

Screenshot 2023-03-14 at 1.20.01 PM.png

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

 

Aaron_Hess
6 - Interface Innovator
6 - Interface Innovator

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