Hi appsheet community,
I’ve an ORDERBY() challenge:
I want to organize my dropdown column [places] according to their popularity. For this purpose, in the table next to the column [places] I created a virtual column [popularity] with a count formula that adds up the number of times that space has been selected.
For the dropdown I wanted to use this formula:
ORDERBY (Brussels [ID], [places]) => dropdown is ordered alphabetically in places.
Is there a way I can arrange [places] via [popularity]?
ORDERBY(Brussels[ID], [popularity], TRUE, [places], FALSE)
That should order it first by popularity descending, then by places alphabetically, ascending…
@Diogenes_ASBL_VZW This is a useful setup, can you please post your VC Count formula setup? Thx!
Fantastic!
VC Formula: [popularity] =COUNT(SELECT(Registration[ID], [_THISROW].[Places] = [Places]))
Registration: table where user fill in the places of interest. [_THISROW].[Places]: refering to the column places of each row in tabel registration
[Places]: column in table
I hope this helps … Greetings
@Diogenes_ASBL_VZW Glad it worked out!
@Grant_Stead In the case you use a dependend dropdown, it seems you can’t use orderby()?
Is this correct?
thx
@Diogenes_ASBL_VZW not sure
For the dependent dropdown you could try to use SORT expression.
Here is a formula that works to order a dependent dropdown column:
=IN([_THIS], Orderby( SELECT(List Lieux[Lieu],[_THISROW].[Sorte Lieu]=[Sorte Lieu]), [Nombre Interventions],True, [Lieu],False ))
Translate
User | Count |
---|---|
60 | |
25 | |
13 | |
12 | |
6 |