Most RECENT date pull

AppSheet AppSheet Q&A
1

I was using this formula in my workbook before moving over to build out my app:

=max(index((A7=‘Activity Log’!$C$2:C)*‘Activity Log’!$A$2:A,))

This pulled the most recent contact date from the Activity Log for the matching contact value in A7.

How can I do this in AppSheet for my CRM table and utilizing the information in my Activity Log?

2

MAX( SELECT( Activity Log[contact date] , [contact] = A7 ) )

Replace “A7”.