I need max to return only the column value, not the entire row

AppSheet AppSheet Q&A
1

I need the most recent “target date” (column value) from the table “Record” where “Target Name” in table Record matches the “Target Key” where this expression lives

I have tried

LOOKUP(MAX(SELECT( “record”[target date], ([_THISROW].[Target Key] = [Target Name]) ) ))

but it gives me the following error

“Function ‘LOOKUP’ should have exactly four parameters: LOOKUP(lookupValue, tableName, lookupColumn, returnColumn)”

Thank You in advance,

2

hello,

look this : https://support.google.com/appsheet/answer/10107920?sjid=4323320065697431288-EU

anything like that :

select( “record”[target date], In([your id],maxrow(“record”, “target date”, [_THISROW].[Target Key] = [Target Name])))

3

I figured it out.

Here is what worked:

max(select(record[target date],[Target Key]=[_THISROW].[Target Key], ))

simple now that I see it.

1 Like