Hi team,
I have a list of users sorted by quantity of times that it appears en main database.
But when I want to create a new row the drop list of users to select appears sorted as I created in the initial spreadsheet document.
How can i solve it?
thks
You need a list sorted by the order that they are in the spreadsheet?
ORDERBY( list , [_rownumber] )
Where list
is a list of key column values from the rows to sort.
See also:
No Marc, I need the opposite, I want to sort (max to min) as a โcount of timesโ (row of my appsheet) that one user has been selected.
I attached example of spreadsheet. In appsheet appears in same order and i want to sort by counts from max to min.
Missatge de Marc Dillon via AppSheet Creator Community appsheet@discoursemail.com del dia dt., 31 de marรง 2020 a les 20:26:
Please review the article for ORDERBY() that @Steve supplied above. There is an optional argument you can supply to sort in descending order.
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |