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!