Title
Max formula
Post
Need to find the dollar value of an entry that is related to the most current date in an array of dates.
I thought I could use an "If " formula by finding the max in the date column and then the corresponding dollar amount. Just can't seem to get it together.
Any ideas?
You can sort your relationship so that the most recent date is sorted on top. Then if you get the value in the "Dollar Value" field form that related table it will get the most recent one.