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 you have read our privacy policy.

Browse other questions tagged or ask your own question.