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))
By the way: The Help page for CONTAINS() is not available.
https://help.appsheet.com/expressions/functions/contains
Solved! Go to Solution.
Hi @Fabian. I found the bug and the fix should go out by tomorrow. Thanks for bringing this to my attention.
Hi @Fabian. I found the bug and the fix should go out by tomorrow. Thanks for bringing this to my attention.
Also, @Steve FYI about the CONTAINS
help page.
User | Count |
---|---|
44 | |
28 | |
28 | |
21 | |
13 |