Return previous answer to different column

AppSheet AppSheet Q&A
1

Hi,

I have a first table QUESTION with the column : Are you a man or a woman?

I have a second table ANSWERS where I would like, in a virtual column, return the answer from that previous question in text format.

Is there an expression for this ?

Thanks a lot !

2

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

How do I get a column value from the last row of this thing only? LOOKUP( MAX( SELECT( My Table[_ROWNUMBER], ([_THISROW].[Thing] = [Thing]) ) ), “My Table”, “_ROWNUMBER”, “Wanted Column” ) Replace My Table with the name of the table from which you want the column value; Thing with the name of the column containing a value that identifies the thing you want (e.g., Order ID); and Wanted Column with the name of the column whose value you want. See also: MAX()

1 Like