Hi Community,
I have a table with 3 columns viz Type, Item and itemCount. I want to display the values of column โItemโ as a dropdown in my appsheet and I want that dropdown to be sorted based on the descending order values of column โItemCountโ. I used Orderby formula โorderby(variables2[_RowNumber],sort(variables2[ItemCount],true),true)โ but this formula returns the key values of my table and not the values of column โItemโ. I donโt think even the row keys are being returned in the correct sorted order.
Any help is greatly appreciated. Thanks in advance!
Solved! Go to Solution.
Yes, a โdereferenceโ. Thereโs a single dereference with the dot notation, and a list dereference like I just mentioned.
There is no way to sort a non-key column by a different column in the Table, in a single expression.
You need to enter this formula into a column first:
ORDER(FILTER(...))
Then in another column/expression you can use a โList Dereferenceโ
[above column][column wanted from sorted table]
Isnโt there any way to get a non key column from a key column. Sorry if it is a dumb question. I am new to appsheets.
Yes, a โdereferenceโ. Thereโs a single dereference with the dot notation, and a list dereference like I just mentioned.
Thanks!
For reference:
Thanks Steve
User | Count |
---|---|
42 | |
29 | |
25 | |
23 | |
13 |