I have a table shipments and shipment_stat_reports that has a column “status” and “timestamp” at the time of the report. I want to build a virtual column that displays the last status of the shipment based on the most recent update but I don’t know how. I’ve tried with filter and select but no success
Solved! Go to Solution.
Hi @Rene_Casana
Maybe check out MAx and MAXROW
https://www.appsheet.com/Support?idx=help&p=0&is_v=1&q=MAX
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |