Returning the first item from Lookup() results

AppSheet AppSheet Q&A
1

I have a Lookup() that matches 7 rows (dates) from which it returns a random row - how do I get it to always return the first (earliest) row? OrderBy and Index?

2

https://help.appsheet.com/en/articles/2357311-minrow

2 Likes
3

Thanks Marc… I thought MIN would be in there somewhere!

1 Like