Skip to main content

Questions tagged [sorting]

Sorting is the process of applying some order to a collection of items.

36 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
5 votes
1 answer
1k views

How to organize Youtube play lists in Alphabetical order under the Save button?

I've created many YouTube playlists and it's getting harder and harder to find the right playlist when I click on save as they are not sorted alphabetically. Is there a way to sort the playlists ...
PinkSamurai Fairlady's user avatar
4 votes
0 answers
362 views

How to make "Highest Rated" the default on yelp.com

Whenever I start a new search on Yelp, it sets the sort order to "Best Match." Is there a way to have the default be "Highest Rated" instead? If I can't figure anything else out, I'll set up a ...
Michael Hoffman's user avatar
3 votes
0 answers
623 views

How to sort Youtube subscriptions by updates?

When I enter YT on the left pane I have "Subscriptions" section sorted by the date of the subscription. So as the effect I could have: Subscriptions A D 1 E F G 7 --- show more --- B 3 ...
greenoldman's user avatar
3 votes
0 answers
818 views

How to display and sort all Google+ posts based on most voted video/photo?

I would like to display all Google+ posts into my website and I would like to categorise them into: most voted video/photo most recent video/photo How can I achieve the above? I know how to embed ...
sree's user avatar
  • 179
3 votes
1 answer
2k views

Simultaneously sort multiple ranges on a single sheet in varying orders

I am trying to find a way using a script if possible (or formula) that will allow me to reduce the number of operations that I have perform to sort data in a particular google spreadsheet. Currently, ...
Max's user avatar
  • 31
3 votes
0 answers
177 views

Sort Delicious bookmarks from all users by popularity

When on the Delicious homepage there is the hotlist > popular bookmarks. This only shows very few bookmarks. Doesn't seem to be actually tagged bookmarks ranked by number of times saved by different ...
Hauser's user avatar
  • 219
2 votes
1 answer
2k views

Auto sorting by multiple columns in Google Sheets

I have a data-set which I would like to have sorted with first column 6 and then column 7. From this post: How can I make some data on a Google Sheets auto-sorting? I have gotten ideas about making a ...
Jesper Homann 's user avatar
2 votes
2 answers
53 views

Auto Sort different ranges

I have a google sheet that I would like to sort different ranges by the 2nd column in each range. Example: A B C D E F G p 7 1 h 9 1 q 6 2 j 3 2 g 9 3 p 7 3 I need the range A:C sorted by B ...
Erin's user avatar
  • 21
2 votes
1 answer
1k views

How to use Google Scripts w/ spreadsheet and jotform to auto sort so the newest entry is always listed on the top row?

I'm trying to setup a form and spreadsheet database to track inventory on a daily basis at a remote location. The idea is that the person at the remote location can update our stock via a simple ...
user40937's user avatar
1 vote
1 answer
25 views

I can sort normally using mouse, but keyboard shortcut gives error

When I select a cell range and go to Data>Sort Range>A to Z, it works perfectly! but when I select a cell range and press Alt + D + S + A, then it gives me an error that few of my cells are ...
dudeAwesome's user avatar
1 vote
1 answer
15 views

Sorting a range of data based on a column within that data

I have a set of data spanning columns A through P in Google Sheets. I would like to add a column in Q that will return the values of A based on the top values of column P. I assume this can be with ...
Colin Davis's user avatar
1 vote
0 answers
34 views

Gmail & Filters

I have set up filters in Gmail to attach a label to specific emails and have checked the box marked "skip inbox/put in the archive". However, some emails get marked with the correct label ...
liz's user avatar
  • 11
1 vote
1 answer
21 views

How do I sort indexed data from a form and maintain list from a range input added afterwards?

I want to sort the responses by names alphabetically Column A (Simple) I want to apply payment types from a drop down linked to the person's name Column G (Simple) I want to do both of these things ...
Sheetsrookie's user avatar
1 vote
1 answer
44 views

How to order column groups by a cell's value

I have a spreadsheet of multiple datasets in columns. I checked some documentation here, https://support.google.com/docs/answer/3093150, but the SORT() function would order my columns on a column-by-...
André Emery's user avatar
1 vote
0 answers
18 views

Formula to automatically sort range of data into groups in different columns by colour?

I am an educator trying to find a way to automatically group students into broad groups of 'below' 'at' and 'above'. My data is more specific (i.e. numerical value between 0 and 30) and I would like ...
user296260's user avatar
1 vote
1 answer
2k views

Google Sheets App Script Sorting

I'm trying to have an auto sort function only impact one sheet in a workbook rather than all of them. I've done this in other projects and def messed this up along the way - any help is appreciated!! ...
HelplessinHyannis's user avatar
1 vote
1 answer
4k views

Auto Sort Google Sheet using onEdit Function and prioritising certain cell values

I have a populated table where I add a prioritisation queue number in the final column. The identification of each row is defined be email OR SMS and the prioritsation queue is labeled as such. I ...
Terry's user avatar
  • 11
1 vote
1 answer
125 views

How to sort by merged cells in Google Sheet

I have been using this script for sorting and so I know it works. Now I'm trying to use it on a new Google Sheet project. Except that the column I want to sort the entire sheet by isn't just one ...
salyela's user avatar
  • 111
1 vote
1 answer
39 views

Sort sentences based on formatting

I have a list of sentences in Google Sheets, each word in a different column. There is a stupid man. How we came here we don't know anything about. Finally, it has come to this. Shaking my head. How ...
ksl's user avatar
  • 11
1 vote
0 answers
191 views

How do I sort Glassdoor reviews by rating on a computer?

The Glassdoor mobile app in both iOS and Android has an option to sort and filter reviews. As far as I know this does not exist on the computer version of the Web App. How do I sort Glassdoor ...
isakbob's user avatar
  • 113
1 vote
0 answers
113 views

Change default sorting on Google Analytics' Dashboard page

We have implemented Google Analytics (GA) for our website and ended up creating 25 dashboards. The issue is every time I go to the Customisation => Dashboards on GA, it shows the dashboards sorted by ...
Oshan's user avatar
  • 11
1 vote
0 answers
763 views

How to automatically sort a filtered list that's always changing in Google Sheets?

I have a complex spreadsheet that rolls up data from all over the place into a filtered list. We need to sort this filtered list, along with notes added afterward in columns to the right of the filter....
Marie's user avatar
  • 11
1 vote
0 answers
55 views

How to sort posts by topic from people I follow on Pinterest

I want to be able to sort the pins from people I follow by topic. So I want to be able to see only Food posts from people I follow (or Fashion or whatever), not from everyone. Is there any way to do ...
BikerOfTheApocalypse's user avatar
1 vote
3 answers
1k views

Using UNIQUE and SORT together

I'm currently using UNIQUE to look through a spreadsheet and display in another spreadsheet all the unique names in a certain "Name" column. However, I need to sort these names by another column ...
Clay Harper's user avatar
0 votes
0 answers
28 views

Retain Row Formatting When Sorting

After performing a sort, the row's formatting doesn't retain it's row height and other custom format, and the row the data was in previously will retain the prior height/format instead of becoming the ...
Jinian's user avatar
  • 1
0 votes
0 answers
923 views

How to sort pivot columns in Looker Studio in Viewer mode?

If it's a table, all one has to do is click the column's title or right click and choose Sort By: [ How can the same be achieved to pivot tables?
LWC's user avatar
  • 1,240
0 votes
1 answer
1k views

Why is Sort range not working?

In Google Sheets I have a column inProduction that contains one of the following text values: TRUE, FALSE, Z N/A. When I sort my range I expect the following order: # Ascending # Descending ...
WurmD's user avatar
  • 101
0 votes
1 answer
1k views

How to sort by percentage on Google Sheets

Now I am doing a tournament. So what I have right now is Column A is Character Names. Column B is their win Percentage. What I want is for Column C to have the Character Names in order by their Win ...
Chillers's user avatar
0 votes
0 answers
215 views

Automatically sort 1 sheet on edit

I have a google spreadsheet with multiple sheets. On one of the sheets, we use Zapier to populate new rows of data when a meeting is scheduled with our team. I'd like the sheet "Meetings" ...
Matthew D's user avatar
0 votes
0 answers
109 views

How to automatically custom sort a Google Sheet by status

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 ...
Liliya Kostadinova's user avatar
0 votes
1 answer
60 views

Auto sorting / copying data based on inputted data?

Sorry if this is a bit confusing or if I’m not explaining this well enough. Using my provided picture as an example how would one auto copy data that gets inputted into that table based on estimated ...
4tWinks's user avatar
-1 votes
2 answers
596 views

Problems when sorting a Google sheet that someone else is editing

In the past, when two people were editing the same Google sheet, if person A attempted to do a sort they would get a "heads-up" warning that A's sort was going to affect person B. We now don'...
Jacquie B PBJ's user avatar
-1 votes
3 answers
1k views

How do I sort data by size and not in ABC order

I am new to Google Sheets and have only used Excel a little, so Google Sheets is a bit different. I want to sort our band uniforms in size order from smallest to largest but Google Sheets only sorts ...
user225620's user avatar
-1 votes
2 answers
4k views

Cannot Find Function 'getRange' in Google Script

I'm working on setting up a series of scripts for a google sheet where I want to be able to auto sort based off of when something gets entered into the third column, sorting first by the first column (...
user220818's user avatar
-1 votes
1 answer
23 views

Sorting column A with drop-down and column B with checkbox

I have a spreadsheet that I use to run a foosball tournament, and in column A I have a dropdown data validation that will let me select a players name. In Column B I have a checkbox that I check once ...
Bryan's user avatar
  • 1
-4 votes
1 answer
2k views

Simple row references in Google Spreadsheets and resorting data

This is my scenario Users are entering data into rows with several columns Last column is calculated on values of few previous columns (so it's row number independent). While entering new and ...
Robert Koritnik's user avatar