My Google Sheet

I would like to know how to make it so that it sorts by subscriber count(Lowest to Highest) ➜ Have contacted (Yes is first and no is last) ➜ If they have accepted it on the top if they haven't responded in the middle. IF they decline I would like them to go all the way to the bottom(still being sorted by subscriber account.

I can do this manually by the data and then sort range but I'm looking for an automatic alternative. Any suggestions?

I guess to put it simple is there a way for me to sort data in a hierarchy as well as some data not being in alphabetical order(Example sort [Common, Rare, Legend] or in my case [Accepted, No response, Declined]. But then having it so that if its declined its at the very bottom of the sheet.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.