MAXROW(table-name, column-name[, select-expr])
MAXROW() identifies a row in the table named by table-name that contains the maximum value for the column named by column-name.
Both table-name and column-name must be a literal Text values; they cannot be expressions.
Commonly, column-name is a name that has a special meaning to AppSheet internals, such as date, n, t, text, time, and others. Whenever AppSheet encounters such a name as literal, unquoted text, it may produce an error indicating the expression "could not be parsed due to exception: #VALUE!". To avoid or fix this problem, enclose the problematic text in quotes.
select-expr is an optional expression that returns a Yes/No value (TRUE or FALSE) indicating whether a row should be considered in the operation. select-expr is evaluated once for each row in the table named by table-name.
A Ref value: The key of a row in the table named by table-name that contains the maximum value found in the column named by column-name.
Note: it is possible the maximum value may occur in multiple rows, in which case one of those rows is chosen arbitrarily to be returned.