ORDERBY and SELECT with 2 items to be filtered

AppSheet AppSheet Q&A
1

I need to sort and filter rows at the same time. I have 2 items to filter out:
[Milestone] “13 Closed”
[Milestone] "14 Funded

The expression below works fine, I just need to add the 2nd item and dont know how

Current expression
ORDERBY(SELECT(customers[ID],[Milestone]<>“13 Closed”),[Customer],FALSE)

Please help
Thanks

2

Hi @teamMedina
Check out AND()

2 Likes
3

Yes, what @Lynn said … you can use AND() to combine filtering criteria in the SELECT() function

2 Likes
4

Where do I write the AND?
ORDERBY(SELECT(customers[ID],[Milestone]<>“13 Closed”),[Customer],FALSE)

5

WillowMobileSystems:

you can use AND() to combine filtering criteria in the SELECT() function

In the SELECT(). It would look like this:

ORDERBY(SELECT(customers[ID], 

               AND([Milestone]<>“13 Closed”, [Milestone]<>“14 Funded”)),

        [Customer],FALSE)
1 Like
6

Naiiiiissss… it worked. Thank you Lynn and John for taking the time … Enjoy the holiday weekend

Cheers
TM

4 Likes
7

@teamMedina
Good work!

1 Like