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

learn more… | top users | synonyms

2
votes
1answer
191 views

Auto Sort data in Google sheet, but by sheet not range

I have found this script from this question to auto sort a column: How can I apply a script to only one specific sheet within a spreadsheet function onEdit(){ var sh0 = SpreadsheetApp....
17
votes
3answers
14k views

How to reverse the order of selected rows?

Is there an easy way to reverse the order of selected rows? (Or how about all rows, if that's easier.) Specifically, in this case, there is no column that could be used for sorting to get them in ...
1
vote
0answers
22 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....
2
votes
2answers
1k views

Sorting title with numbers in Google Drive

When I sort by title in Google Drive, I would like it to numerically go 1 → 2 → 3 … etc., but instead it goes 1 → 10 → 100 → 1000 → 1001 → 1002 … etc. Is there any way to get it to do the first ...
0
votes
0answers
10 views

Google Sheets Autosort without using additional sheets [duplicate]

I am looking to create a dynamic task list on Google Sheets, such that the columns are sorted alphabetically (I have put A: B: etc in front of the things I want to sort so that it can work) ...
2
votes
1answer
28 views

Can I protect rows in a Google Docs spreadsheet from sorting?

I can sort a Google Docs spreadsheet on any column, but that sorts ALL of the rows. I don't want to sort the rows that contain the column labels. Is there a way to protect them from being sorted? I ...
2
votes
1answer
56 views

Auto Sort Google Sheet with onEdit function

The following function successfully sorts my file (containing 3 sheets) individually. When I hit the "play" button on the script, it properly sorts (as expected) the current (active) sheet. Since my ...
2
votes
2answers
365 views

How to sort cells with text and numbers correctly

This is my example list: example file As you can see I am sorting all unique elements in row B. But the "Sprint 9" gets sorted as the highest value, not the lowest. I really have no clue how I can ...
3
votes
1answer
229 views

How can I sort all worksheets in my Google spreadsheet on open?

I have successfully been able to sort the first sheet in my Google Spreadsheet onOpen, but I'd like to sort all four spreadsheets onOpen and I can't make this work. I've tried quite a few variations ...
1
vote
2answers
173 views

Auto sort a sheet so that entries remain in their categories

So I want to sort my Spreadsheet on Google but it remain in the Categories that it's laid out. I can get to it sort double columns but the categories get messed up as they move away from where they ...
1
vote
2answers
458 views

Auto sort of Forms responses so that the most recent one is on top

We use Google Forms to collect guest surveys for our resort. New responses get added to the bottom of the response sheet. While we can manually sort the responses using the time-stamp feature, not ...
1
vote
1answer
101 views

Google spreadsheet sort auto update

I have this table, which is a ranking, the values are updated automatically (data gathered from other files). What I want is that every time this values are updated the ranking automatically updates ...
0
votes
2answers
29 views

How to sort spreadsheet by date+time column but with a modified hour column?

I have a spreadsheet generated by a google webform and it produces a standard spreadsheet with a full timestamp column that is two hours behind and a hour column (hh:mm am/pm) that the user fills in ...
3
votes
1answer
142 views

How to sort groups of rows in Google Sheets?

I have a spreadsheet with lots of related rows. How can I sort the entire sheet in such a way that rows that belong together stay together in groups, and the groups instead are sorted by some common ...
2
votes
1answer
82 views

A simple spreadsheet sorting

In a Google Spreadsheet I have different groups of cells in one column to auto-sort. All cells in this column have same pattern of data, all datum have it's own cell and it's needed to be sorted into ...
5
votes
1answer
20k views

Sort Gmail by Date? [duplicate]

Possible Duplicate: Is it possible to sort your email in GMail by something other than the date received? Is there any way to sort Gmail by date in the web interface? The priority inbox is ...
1
vote
1answer
2k views

Sorting Google spreadsheet by month and day but not year

I made a Google spreadsheet with a list of birth dates, anniversaries, etc. that I would like to sort by when they occur in the year, not when they first happened. If you sort by the date normally, ...
2
votes
1answer
85 views

How to sort by date with Google Spreadsheet?

Consider the following text in a single column in a spreadsheet: AAPL 2015 Dec 18 C @ 185.000 AAPL 2016 Mar 18 C @ 160.000 ... How to sort by date? I tried extracting the date using regex, but it ...
1
vote
1answer
248 views

Sorting alphabetically (A-Z) ignoring beginning “A”, “An” and “The” using a script

I have a Movie list using Google Sheets that I would like do some sorting with using a script rather than a formula. Column A is the movie Title. I would like to be able to sort the movie titles ...
-1
votes
1answer
261 views

Google Sheet: How to Sort Names in Column Alphabetically Ignoring “The”, “An” & “A”… and then pull names (skipping duplicates) into another tab [closed]

I have searched here and all over the web. I've found ways very close to some of what I want but can't really get close what i'm looking for. Especially as complexly as I want it. I apologize if I ...
3
votes
2answers
4k views

How can I alphabetize a unique result in Google Spreadsheets?

I'm generating a list based on using the UNIQUE function. How can I get the output to be alphabetized automatically?
1
vote
1answer
555 views

Filter Google Spreadsheet Array Formula

I have a spreadsheet with 2 columns. B1 contains a custom function that returns an array that overflows to fill the column. I want to create a few filter views that each show all entries with 1 given ...
1
vote
1answer
493 views

How to combine and consolidate rows from multiple sheets into one and sort them?

I've few sheets where rows are populated dynamically via IMPORTXML and ImportJSON with the same columns, but they can't be sorted. So I'd like to generate new sheet which will populate rows from ...
4
votes
1answer
121 views

Sorting a list with points in Google Docs

In Google Docs, how would I go about sorting a list of chapter numbers (for example) with points in between, e.g. 1.1, 1.21, 1.3 in the right way so that 1.21 follows 1.3?
1
vote
1answer
96 views

Is there any way sort Trello cards by custom values?

I sort my bucket list by a ((how much it excites me)*(how much value it will bring me)*(probability of success)/(cost in hours)*(days until [self-imposed] deadline)). Is there any way to assign such ...
1
vote
1answer
354 views

Google spreadsheet multiple auto-sorting

In a Google Spreadsheet I have different group of cells to auto-sort ascending i.e. table range a3:c16 columntosortby = 2 table range d18:f31 columntosortby = 5 table range g33:i46 columntosortby = ...
2
votes
1answer
83 views

How to sort Google Sheets columns by row height

I'm working on a sheet that involves multiple columns corresponding to various data. Each column has a varying number of cells of varying heights with wrapped text. What I want to do is make the sheet ...
4
votes
1answer
2k views

How to sort posts on Reddit by number of comments?

How to sort posts on Reddit by number of comments? I'd find this more useful than sorting by votes.
1
vote
1answer
434 views

Sort Google Drive by date added [duplicate]

Is there a way to sort Google Drive (either iOS or web version) by date that a file was added? It drives me crazy that if I use Gmail to save an attachment to Drive, I can't locate that file ...
1
vote
3answers
1k views

Missing sort in Google Spreadsheets menus

I have a Google spreadsheet that has the A column as an ID field (incrementing numbers 1...1000; no formula, just numbers). That column is frozen as is the first row of headers. I sorted by column B ...
2
votes
1answer
264 views

Prevent Gmail from applying multiple labels

I have recently imported all my mail from Outlook.com and my work email into the gmail accout and I have started to organize the messages using labels. The filters work great and I have managed to ...
2
votes
1answer
1k views

Sorting a protected range in Google spreadsheets

I've been trying to make the spreadsheet automatically sort some data, and after some searching I found this post: Automatic sorting. It works just perfect with my permissions as the owner, but when ...
4
votes
2answers
900 views

Is there a way in Google Sheets to order blank cells first?

When I sort a column in Google Spreadsheets, the blanks always seem to sink to the bottom. Can I have rows with blank cels be organized first / highest? Alternatively, is there a function wherein I ...
2
votes
2answers
156 views

Altering the Sort Filter in Google Spreadsheets

I live in Australia and when I'm putting in dates, I place the date, followed by month then the year. However when I am filtering/sorting my spreadsheet it's coming up incorrectly. How do I edit ...
1
vote
0answers
47 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 ...
3
votes
0answers
379 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 ...
1
vote
1answer
39 views

How can I preserve sort order?

Is it possible to get Google Music to preserve my selected sort order? I'm getting tired of clicking the "Artist" column header to sort by artist name every single time I switch views.
0
votes
1answer
1k views

How to GROUP and ORDER data in a Google Spreadsheets?

I want to group and sort a particular data set. I've prepared the data using a QUERY function and using other functions. Can I order by sum? This is an example file I created: order by sum
0
votes
1answer
71 views

Google spreadsheet, sort adds a bunch of rows

I have a function that sorts a table, unfortunately when I call my function it adds a bunch of empty rows at the bottom that I don't like. var kotlijst = SpreadsheetApp.getActiveSpreadsheet() ....
1
vote
0answers
242 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, ...
7
votes
2answers
169 views

Sort Gmail messages by how long people have been waiting for a reply

I am trying to help someone break the habit of delaying too long in replying to emails. For a select group of email senders in Gmail, I'd like to set up some way of seeing how long it has been since ...
0
votes
1answer
3k views

Show new mails at the top in outlook.com inbox

While trying to read inbox, I expect to view new emails from top down order. While it works in every other mail box, in outlook.com, my Hotmail doesn't show in that manner, if I have create new mail ...
2
votes
0answers
108 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 ...
13
votes
3answers
2k views

Is it possible to sort your email in Gmail by something other than the date received?

I want to sort my email in Gmail by the sender, rather than the date received, is there a way to do this?
1
vote
1answer
266 views

How Many Ways To Sort in Google Spreadsheets

When I'm working in a Google Spreadsheet, I always use the same routine to perform a sort. Are there more ways to sort, that lead to Rome?
0
votes
2answers
935 views

How do we actually do list sorting in Google Bookmarks (alphabetical order)

I use Google Bookmarks and I’d need a way to sort all my lists in alphabetical order. The "My lists" current has itself sorted in last modified order... and although that’s useful, it is more useful ...
1
vote
0answers
678 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 ...
1
vote
1answer
177 views

Is it possible filter messages in Hotmail using boolean OR / AND conditions? [closed]

Is there any trick to put different criteria in one folder? Or add criteria in a field with boolean conditions? Is it only possible to add a condition and a new folder (not in an existing folder)?
-2
votes
1answer
994 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 ...
2
votes
1answer
941 views

Sorting Unique rows by a related Sumif column in Google Spreadsheet

I am putting together a worksheet to keep track of expenses. I currently have the following source table called "Expenses": A B C D 1 Date Description ...