I have to sort a sheet of data based on changeable values of dropdowns for each row.

For example, I want all the waiters that are on-shift to have a "Ready" status from the dropdown. Those off-shift to have "Off-shift" status etc. Status is changed manually from the dropdown for each person, however, I need all the "Ready" waiters to appear on top, then all the "Off-shift" ones, then "On-vacation" ones etc. Each time a status from the dropdown is changed, the list should be re-sorted automatically.

As a novice I feel quite clueless on how to achieve this.. I tried to write a script based on similar cases I saw but it isn't working at all. Any clue on why and how it could work?

Any help would be appreciated!



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.