virtual column that brings the value of the previous line of this ID .

AppSheet AppSheet Q&A
1

DEVIMPLOY_Autom_0-1660766048886.png
DEVIMPLOY_Autom_0-1660766048886.png708×343 13.3 KB

virtual column that brings the value of the previous line of this ID .

The user makes the first launch and the previous launch does not exist, when he edits and changes the value the virtual column shows the value that is in the previous line of this ID

I created a release A then edited it to B , it will show the value A in the virtual column, so on , as if it were a before and after

2

If you are OK to use the _ROWNUMBER, that is, the rows are always created orderly in the spreadsheet, you can get the value of current release of a previous row by

LOOKUP(
 [_THISROW].[_ROWNUMBER] - 1,
 "you table",
 "_ROWNUMBER",
 "current release"
)
1 Like