How do I reference the value of the previous row?

AppSheet AppSheet Q&A
1

I am creating a weight recording application.
I want to use a virtual column to find the increase/decrease value from the previous record, but it doesn’t work.

LOOKUP([_ROWNUMBER]-1, “log”, “_ROWNUMBER”, “weight”)

I tried the above formula, but it didn’t work.

2

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks ?

Core concepts & functions Expressions: The Essentials FILTER() List Expressions and Aggregates LOOKUP() MAXROW() MINROW() REF_ROWS() SELECT() What is a Key? Adding & updating rows Is this a new row?/Does this row already exist? What is the previous value of this column? Excel alternatives How do I do COUNTIF() or COUNTIFS()? How do I do SUMIF() or SUMIFS()? How do I do VLOOKUP()? Last row of the spreadsheet How do I get the last row of the spreadsheet? How do I get a column value from…

3

Try this:

LOOKUP([_THISROW].[_RowNumber]-1, “log”, “_RowNumber”, “weight”)

4

Wow!
It worked.
Thank you!

5

Welcome!

6

It’s not working.

Please check

7

I am building a similar app, and was having a similar problem. I tried your selected solution, but it was only getting the last row of the table for some reason. I tried this, and it is seeming to get the job done.

LOOKUP(MAXROW(“Measurements”, “Weight (lb)”, [Date] < [_THISROW].[Date]), “Measurements”, “Measurements ID”, “Weight (lb)”)