Hi want to ask how do i select the row cell o...

[Liang_Chieh_Poh]

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.

[Suvrutt_Gurjar]

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.

help.appsheet.com - List Expressions and Aggregates List Expressions and Aggregates help.appsheet.com

[pravse]

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.

[Liang_Chieh_Poh]

May i know how do i use LOOKUP(), i seem to find a difficulty for this.

Example:

i want to LOOKUP() for the numbers of “9” in the column D:D

[Suvrutt_Gurjar]

Hi @Liang_Chieh_Poh, Lookup expressions typically have search and return value and columns. For spreadsheet syntax of Lookup expression you may take a look at

support.google.com - LOOKUP - Docs Editors Help LOOKUP - Docs Editors Help support.google.com