Wow, I swear I've asked this AND seen it answered, but can't find it.
I've created a junction field that contains the sponsor name and a single select field for the year:
On the table where the sponsors originate, I want to show the MAX year. I've tried lookup and rollup and various suggestions from the forum, but I always get "0." Here's the current set up, based on a suggestion from @kuovonne in a previous thread. Instead of a rollup field, I have a lookup, then a formula to output MAX.
The lookup is great, but you can see the formula always shows "0." The formula I'm using is
I know I'm missing something obvious, but can't figure out what it is. Thanks!!