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?
MAX( SELECT( Activity Log[contact date] , [contact] = A7 ) )
Replace “A7”.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |