Sort a column based on another column

[Mayank_Gupta]

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!

[Marc_Dillon]

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]

[Mayank_Gupta]

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.

[Marc_Dillon · Accepted solution]

Yes, a “dereference”. There’s a single dereference with the dot notation, and a list dereference like I just mentioned.

[Mayank_Gupta]

Thanks!

[Steve]

For reference:

help.appsheet.com

Dereference Expressions

Use a dereference expression to get a column value from the referenced row.

help.appsheet.com

FILTER()

Select rows of table or slice

help.appsheet.com

List Dereference

Dereference the items of a list in bulk to produce a list of the resulting values.

help.appsheet.com

ORDERBY()

Sort row references

[Mayank_Gupta]

Thanks Steve