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?
LinkedIn
Twitter
