Hi…
how to sort numbers from smallest to largest based on HARGA JUAL
in Ghseet I use the RANK formula,
As far as I’m aware, in Glide tables you never sort your rows. That’s done when displaying. You’ll see in collection components (eg list) you can sort the view by sheet order or by a column value.
Does that satisfy your need, to sort your list viewed in app?
2 Likes
If you do actually need to rank the data, then the new Query column will help you with that.
Thanks @Darren_Murphy
I’ve created a query column, next I want to create a dynamic label that determines the winning number, is there a way to do that?
I want to sort selling price from smallest to biggest, I want to use that for the title component
Thanks @MatthewS
is there a way for this?
is there a way for this?
Hola,
If I were you, I’d do it this way:
-
Lookup the Price column to get a Price array
-
using the Sort Array plugin, sort Price[ ] column
-
then, use Find Element Index plugin to build your ranking looking for each price in Price[ ] column
That’s all! 
Saludos!
Here’s an alternative with Query.
Use a query to sort based on the price.
Use a lookup to return the list of rowIDs based on the query.
Use “find element index” to return the index of the row.
Use a math column to return the final rank (index + 1, since index starts from 0)
1 Like
hi thin thanks for the response.
what if the case is like this:
Arisan group column
KELOMPOK 1 has 5 different prices and has a rank from 1 to 5
KELOMPOK 2 has 7 different prices and has a rank from 1 to 7
1 Like
Adjust your query so that “Kelompok arisan” equals to this row > “Kelompok arisan”. Then everything else should follow.
1 Like
Wow amazing
thank you very much @ThinhDinh , this method works
and thank you very much for your help… @Darren_Murphy @gvalero
@matthews
1 Like
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.