MAXROW() with CONTAINS()

AppSheet AppSheet Q&A
,
1

We can use MAXROW() like:
MAXROW(Customers, SignupDate, [State] = WA) — returns the most recently created customer from WA state.

But it seems that we cannot use CONTAINS() inside of the MAXROW() like:
MAXROW(Customers, SignupDate, CONTAINS([State] , WA))

@tony
@Steve

By the way: The Help page for CONTAINS() is not available.
https://help.appsheet.com/expressions/functions/contains

2 Likes
2

Hi @Fabian. I found the bug and the fix should go out by tomorrow. Thanks for bringing this to my attention.

1 Like
3

Also, @Steve FYI about the CONTAINS help page.

1 Like