How to return a specific column value from a MAXROW() Expression

AppSheet AppSheet Q&A
1

Hello,

I need to return only the date from this expression

MAXROW(“DAILY OPERATIONS”, “DATE”, ([SHOP NAME] = [_THISROW].[SHOP NAME]))

and compare it to

TODAY().

Example, a certain event will happen only if The Date Value, from the date column, of the row returned by
MAXROW(“DAILY OPERATIONS”, “DATE”, ([SHOP NAME] = [_THISROW].[SHOP NAME])) is before TODAY().

Thanks

2

You can try with:

IF(
TODAY() > MAXROW(“DAILY OPERATIONS”, “DATE”, ([SHOP NAME] = [_THISROW].[SHOP NAME])),
TRUE,
FALSE
)
3

Thank you @Rene_Casana_Amaya.

However this returns an error as the formula attempts to compare a constant to a row number.

3X_1_5_1546e527d0eb60270c95551307cd4980c1a20d08.jpeg
3X_1_5_1546e527d0eb60270c95551307cd4980c1a20d08.jpeg1052×359 100 KB

1 Like
4

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()

3 Likes
5

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT()

LOOKUP( MAX( SELECT( My Table[_ROWNUMBER], ([_THISROW].[Thing] = [Thing]) ) ), “My Table”, “_ROWNUMBER”, “Wanted Column” )

This is just what I was looking for!

Thank you so much @Steve

And thanks @Rene_Casana_Amaya

1 Like