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.
How to automatically sort Google Sheet data with a hierarchy
google spreadsheets;sorting