Orderby or sort column

[bpo_caribbean_nv]

Hello, I would like to order the rows in the following template, on the [Croon Tool Number] column from low to high. How can I arrange that in the word template? Thanks Muk

[QREW_Apps]

Hi Muk, try ORDERBY().

So it’ll look something like this:

<<Start: ORDERBY( SELECT(Assigning Tool to[Tool Reservation_ID], AND([_THISROW].[Tool Current Location] = [Tool Current Location], [Assigning Status] = “Assigned”)), [Croon Tool Number], FALSE )>>

*ORDERBY(keys, sort-key, [descending-order, [sort-key]]…)

ORDERBY() - AppSheet Help

Hope this helps!