Filter ORDERBY after SELECT query ?

AppSheet AppSheet Q&A
1

Hello,

Please could you help me to resolv this problem.

I created à formula (Valid if in a column) to get a drop-down list of agencies thatis in another datasheet table with conditions like this :

SELECT(List [Agence],

OR([Situation]=“FR”,[Situation]=“ESP”,[Situation]=“UK”,[Situation]=“DE”))

Now, how can I organize in ascenging the results [Agence] ?

I tried some quiery with ORDERBY combinaison but all return failed.

By advance thank you for your reply.

Regards

2

SORT(

SELECT(List [Agence],

OR([Situation]=“FR”,[Situation]=“ESP”,[Situation]=“UK”,[Situation]=“DE”))

)

1 Like
3

Simply !!!

Thanks a lot diogolupcosta :+1:

1 Like