Orderby() appsheet

[Eschiantarelli]

Hoy Can I use Orderby() with This Expresion?

OR
(
LOOKUP(useremail(), "users", "useremail", "userid") =LOOKUP([_THISROW].[CLIENTE], "TRADER", "CLIENTE", "REPRESENTANTE")
,AND
(
LOOKUP(USEREMAIL(), "Users", "UserEmail", "UserActive") = "TRUE"
,IN(LOOKUP(USEREMAIL(), "Users", "UserEmail", "UserRole"), { "ADMIN"})
)
)

[TeeSee1]

https://support.google.com/appsheet/answer/10107362?hl=en

As in the help doc of ORDERBY, the first parameter is a list of key values of a table.

Then, the first order key (+ descend/ascend flag), second, third...

I do not quite understand what you are trying to do but your expression is of a yes/no type.

So maybe you want to use your expression as the constraint condition of a select statement in the first parameter.