i want to make a "catch up list' to bring out the contact that don't have a event log for more than 1 month
thats what i have donethis is contact master table
Last Appointment Date Formula
Appointment Or Event Log
it dose not work properly unless the created date time is equal to app date time
Formula for column last Appointment Date
Solved! Go to Solution.
MAX( [related appointments...][app date time] )
https://help.appsheet.com/en/articles/4575708-list-dereference
MAX( [related appointments...][app date time] )
https://help.appsheet.com/en/articles/4575708-list-dereference
can you explain more
I got it thank you so much
User | Count |
---|---|
17 | |
12 | |
9 | |
4 | |
4 |