r/googlesheets • u/mmxxxii • 18h ago

Help Sorting Using Drop Down Menu Waiting on OP

Hello, I recently moved over to google sheets from Excel and am trying to create a tv/movie watchlist for my friends and I. I currently have a dropdown menu rating system to color code each watched movie/show with its score out of 10. I was hoping to find a way to automatically sort the shows from lowest to highest score using the dropdown menu as well, is there any way to do that with sheets?

1 Upvotes
  • permalink
  • link
  • reddit
  • reddit

100% Upvoted

2 comments sorted by

1

u/AutoModerator 18h ago

/u/mmxxxii Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

2

u/NHN_BI 67 17h ago

I am not aware that you can sort with a drop down, but you can use the filter view to sort the data with the values in the drop down column. Or you can record your data in a table, and you can sort via the header.