Questions tagged [sorting]
Sorting is the process of applying some order to a collection of items.
1
vote
1answer
12 views
Combing two ranges with identical column structure from two different sheets (in same spreadsheet)
I'm doing a simple ticketing system, where I have two sheets, "Form Responses" and "Email Responses" both of which are populated automatically as their names imply (one from a form, one from an email ...
0
votes
1answer
36 views
Is it possible to make a custom sort on column other than A-Z or Z-A in Google Sheets?
The Sheet has a column with cells populated by a dropdown list offering 3 choices: Good; Very Good; Rejected;
In that context, it would be practical to sort the column according to a specific/custom ...
0
votes
0answers
12 views
How to auto-sort from a drop down box?
Without having to manually auto sort alphabetically, how can I get it to automatically sort when creating a new project and choosing A,B,or C, from the drop down menu in the the first column. See ...
1
vote
0answers
12 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 ...
2
votes
2answers
776 views
Google Sheets, how to sort query results manually (Not in query)
My google sheet is importing data from another tab just for sorting purpose, however, when the sort is done manually (through Google Sheet menus), results are unpredictable.
The sheet is populated ...
0
votes
0answers
149 views
Sorting a sheet without losing group order
I've got a large sheet (tens of thousands rows) grouped into hundreds of different groups. All the groups are collapsed so I only see the top-level cell of each group. Now I want to sort on a these ...
0
votes
0answers
8 views
How to sort emails in folders but also keep them in the inbox (Outlook)
How to sort emails into different folders (by names) AND keep them in the inbox folder? I'm assuming some sort of copy creating thing...?
2
votes
0answers
275 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
...
0
votes
1answer
30 views
spreadsheet conditional: if in top x then
spreadsheet data:
Total Average Highest Top Sales
$23,550.00 $7,850.00 $8,100.00 not
$42,700.00 $14,233.33 $14,400.00 not
$30,500.00 $10,166.67 $10,300.00 not
$37,840.00 $12,613....
1
vote
1answer
824 views
Auto sort script sorting different sheets by different columns
I have a master sheet where data is entered.
I would like the other sheets in the book (which currently auto-populate from the master sheet) to sort (in descending order) by their respective column in ...
0
votes
1answer
1k views
Help with ordering a Google Sheets =QUERY
I'm trying to add an ORDER by F to the following query, but every time I do it returns a syntax error.
ORIGINAL QUERY (working)
=QUERY(data!A2:Z, "select G, E, F, I, J WHERE A = " & C1, "")
...
0
votes
0answers
2k views
How to automatically sort Google Sheet data with a hierarchy
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 ...
0
votes
1answer
2k views
Can I sort rows in Google Sheets by date?
In Google sheets I'm trying to sort rows according to a date column. According to my experience I can use column filtering and choose to sort data from A-Z. However this will give a wrong result for ...
1
vote
0answers
47 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 ...
0
votes
1answer
83 views
I need help with sorting query in Google Sheets
I have a zap that pulls "Email" data from a spreadsheet, I also have a query that pulls "NAME" data from a different spreadsheet, but when I try to sort it, the data gets misplaced, eg. blank rows ...
5
votes
2answers
1k views
How to sort Trello cards by date added
Trello is rad. But one thing I haven't figured out:
How to sort cards in a list by the date that the cards were added to the list (or to the board)?
Also, is it possible to show (as a custom field?) ...
1
vote
0answers
120 views
Filter View: Sort by custom string order
Say I have a spreadsheet containing names, dates and a rank.
The spreadsheet is by default sorted by date but I want to create a filter view that sorts the spreadsheet by the rank column, i.e., "...
1
vote
2answers
259 views
Sort a Google Spreadsheets so it returns 'alternating' values in a column
I have a list of hundreds of students that contains the following data. The only two values that will appear in the gender column (col 3) are male or female:
Current List
fName | lName | ...
0
votes
1answer
802 views
How to filter range and return only specific columns?
This is what I have tried just yet:
=QUERY(FILTER(Recherche!A4:O1002), "select Col1, Col15, Col2, Col3, Col4")
based on this format
=QUERY(FILTER(B:D,D:D>=2),"select Col2, Col1")
What I get is ...
0
votes
2answers
62 views
Sorting Google Sheets by Mailing Address
I have a spreadsheet in Google Sheets (and Excel) that contains companies from many countries. The address cell has the full address including the country.
So:
Company name | Full Address | phone ...
1
vote
0answers
421 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....
3
votes
1answer
6k 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 ...
3
votes
1answer
903 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 ...
0
votes
1answer
700 views
How to sort spreadsheet by date+time column but with a modified hour column?
I have a spreadsheet generated by a Google form and it produces a standard spreadsheet with a full timestamp column, that is two hours behind, and an hour column (hh:mm am/pm) that the user fills in ...
4
votes
1answer
3k 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 ...
3
votes
1answer
668 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
2k 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 ...
-2
votes
1answer
1k views
How to sort names in column alphabetically ignoring “The”, “An” & “A”… and then pull names (skipping duplicates) into another tab [closed]
This is for a Movie Have/Want list using Google Sheets.
Problem 1:
Column A is the movie Title. I would like to be able to sort the movie titles alphabetically but ignore when a movie title begins ...
2
votes
1answer
3k 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 ...
11
votes
6answers
7k views
Sort Google Search results by date?
Is there a way to sort Google Search results by date?
(I know how to limit the search to a particular time period.)
1
vote
1answer
33 views
Is it possible to sort topics in Rizzoma by number of votes?
Overview
As Google Moderator is shutting down on June 30, 2015 (more Info) I would like to learn about alternatives, mainly for educators. Rizzoma topics could include the Yes/No/Maybe Wave gadget, ...
3
votes
1answer
1k views
Auto sort data but by sheet not range
I found this script from How can I apply a script to only one specific sheet within a spreadsheet to auto sort a column:
function onEdit(){
var sh0 = SpreadsheetApp.getActiveSpreadsheet()....
3
votes
1answer
296 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 ...
0
votes
1answer
2k 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 ...
3
votes
2answers
4k 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 ...
1
vote
1answer
1k 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
1k 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 ...
4
votes
1answer
895 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 ...
4
votes
4answers
5k 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 ...
1
vote
1answer
134 views
Sort auto update
I have this table, which is a ranking, whose values are updated automatically (data gathered from other files). What I want is that every time these values are updated the ranking automatically ...
1
vote
1answer
166 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
0answers
54 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
766 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 ...
2
votes
3answers
5k 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 ...
3
votes
2answers
193 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
1answer
82 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()
....
2
votes
1answer
629 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
194 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 ...
5
votes
2answers
7k 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 ...
4
votes
1answer
137 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?
