ORDERBY and SELECT with 2 items to be filtered

[teamMedina]

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

[Lynn]

Hi @teamMedina
Check out AND()

[WillowMobileSys]

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

help.appsheet.com

AND()

Are all true?

[WillowMobileSys]

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)

[teamMedina]

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

Cheers
TM

[teamMedina]

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

[Lynn]

@teamMedina
Good work!