I'd like to double check to make sure that I ...

[Kirk_Masden]

I’d like to double check to make sure that I understand how AppSheet expressions work.

I know I can use the following expression in a virtual column to get the number in the “Session number” column of the “Session” table in the row where the “Key” column equals 1:

=SELECT(Session[Session number],[Key]=1)

To make this work, however, the virtual column has to be a list, not a number.

On a normal spreadsheets, I would only need to type something like

=C2

to get the value of the second row in column C.

Is there any way to do this in an AppSheet virtual column that produces a number, not a list?

Unless I’m mistaken, AppSheet doesn’t seem to work that way.