Hi want to ask how do i select the row cell on top of my current cell in appsheet? Using R[-1]+1 receives Parse ERROR, how can i correct this? Thanks.
Also, depending on your app configuration , you may wish to explore various AppSheet expressions that you can build in AppSheet editor. For building the
LookUp expression and similar expressions in AppSheet ,please take a look at following article.
Hi @Liang_Chieh_Poh, in AppSheet, there is no notion of
“positional” access. Unlike a spreadsheet, the rows in a table are not ordered in one unique way. Each view may show them ordered a different way.
So you will need to refer to the other row logically. So for example, you could use the LOOKUP() function to fetch a value from another row.
May i know how do i use LOOKUP(), i seem to find a difficulty for this.
i want to LOOKUP() for the numbers of “9” in the column D:D