Im trying to get the last most recent row dat...

Im trying to get the last most recent row data for some calculation, So i tried to create a ref by

MAXROW(table name, column name), and set the column as virtual and as Ref, with and without filter conditions, as I saw that the example is doingโ€ฆ https://www.appsheet.com/Template/AppDef?appName=Data-210414&nonce=1902786010#Data.Columns

BUT i get this " could not be parsed due to exception: #VALUE!" when I try to verify the formula. WHY??? any suggestions? please help, im stuck

0 1 361
1 REPLY 1

What is the exact MAXROW() expression youโ€™re using? Iโ€™m guessing it includes an unquoted textual value that has a special meaning deep in AppSheetโ€™s guts. Try quoting both the table and column names.

Top Labels in this Space