Hot answers tagged


It is also possible to use Google Apps Scripts to achieve automatic in-place sorting of the data. This may be more difficult to achieve and more error-prone (I'd still go for William Jackson's solution, +1 BTW), but I thought it was interesting enough to show. I have a sheet that looks like this: I added a new script, using these steps: in the menu, go ...


To reverse the order of the selected range (as opposed to sorting by a specific column), you could use the following script: function reverseOrder() { var range = SpreadsheetApp.getActiveRange(); var values = range.getValues(); range.setValues(values.reverse()); } Adding this onOpen script will create a menu item called Extra, containing an item ...


Here's an example of how to do this without using scripts - please note that this method assumes your data is just data - it might do strange things if you have formulas referencing other cells in the same range: Insert a new column (for the sake of example, we'll call it column A). In A1, put the value [1]. (You can start at A10, or A50 if you only want ...


Use Sort and Unique together. =sort(unique(A:A)) Here are the descriptions of the filter functions for Google spreadsheets.


Click 'Search tools' then select any date filter other than 'Any time'. Then click in the default 'Sorted by relevance' option and select 'Sorted by date'


Here's a generic script that will autosort based on the 1st column, and assumes a Header row. To create a script: In the menu, go to Tools -> Script Editor... In the empty code window, paste the following code, which will run automatically whenever a cell is edited: // LinkBack to this script: //


No, you cannot change the sort order of Google Search results. The sort order is determined by Google's secret recipe. All you can do is filter your search for specific time periods.


Another option without a script is: =QUERY(A1:C3,"SELECT * ORDER BY C") The range is restricted (A1:C3) because where the order is ascending blank entries will appear first.


I have had a similar issue, with trying to sort a UNIQUE dataset. the way i got around it was by creating another sheet and using the '=QUERY()' function to call the sheet with the UNIQUE list on it. This way you can add a ORDER BY statement to the query. so in your example, Expenses has the source data, the summary table has the Summary data (with the ...


You can use Butler for Trello, which is a bot that automates Trello (I'm the author). This command: sort list "X" by time in list sorts a list by the length of time that a card has been in the list. You can also reverse it: sort list "X" by time in list descending You can apply the command at certain times, e.g.: every day at 6am, sort list "X" by time ...


Ultimately, you need to do what you already predicted: adding a leading zero. The TEXT function will make that happen like this: =TEXT(A2, "00") I've created a formula that takes on the complete column, filter for empty cells, brings together the MONTH and DAY and SORTs the lot. Formula =SORT(ARRAYFORMULA(TEXT(MONTH(FILTER(A2:A;A2:A<>""));"00") &...


I add a filter function to keep only cells with data. =sort(filter(unique(A:A);unique(A:A)<>"")) Maybe it could help.


Following Mir's example you may place SORT function into say cell D3 to reverse order for data in column C: =sort(C3:C,A3:A,False)


The best result would be to use the QUERYfunction: =SORT(QUERY(Data!A1:B6;"select A, sum(B), count(B) group by A");2;FALSE) Since the sum already has been sorted ascendingly, the FALSE statement in the formula will sort descending using column 2.


This would be a great feature for me too, but AFAIK it doesn't exist. My solution to cope with such a problem is to use the service called Boomerang. What I do is that I empty my inbox as much as possible multiple times a day (at least once). For any email that would take me longer than 5 minutes to write a response to, I delay it: I ask for it to be "...


Try this instead. Code function onOpen() { var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets(); for(var i = 0, iLen = sheets.length; i < iLen; i++) { var sheet = sheets[i], range = sheet.getDataRange(); range.sort({column: 1, ascending: true}); } } If you want to sort from a certain row or column, then use this code function ...


This is not currently possible but there are a lot of comments and votes for this feature here:


For want of any better answer so far, I suggest copying your list into a sheet, splitting it on . and on then using the 1,21,3 column to sort the sheet before copying and pasting the revised order back into your document - manually rearrangement may be easier!


It is not possible to change order of sorting, according to Netvibes Documentation page: In Reader View, the screen is divided in three main parts: A: list of your tabs and feeds B: selection and display options of the content C: all the currently selected feed items D:...


I do not think you have any way to control the sort order directly, other than ascending or descending, so suggest a lookup table and a helper column (to determine the sort order) with a formula in that such as: =if(B1="",1,vlookup(left(B1,1),E:F,2,0)) where ColumnB is the one to be sorted, ColumnE the sort order and ColumnF a number starting at 1 and ...


You are trying to turnoff one of the strengths of Gmail. A message can have multiple labels. When Gmail puts the work and contatct1 labels it is doing that because the contactx label is a sub-label of the work label. Multiple labels make it easier to find messages/conversations because you can use the presence or absence of labels to filter the results of ...


Rubén and infrcl have good answers. Here is one way you can sort by date, using Search Query Parameters. Assume you want the last two years sorted by date. Search for your term, hit enter You will get a URL, which includes Search Query Params. Copy it. Append &tbs=qdr:y2,sbd:1 to your URL and hit Enter. Now you will have "Past 2 years" and "...


You can achieve that in Firefox by installing Reverse Timeline addon. Reverse Timeline (former:Read All Tweets) Show unread tweets in reverse chronological order to read easily on twitter. You can also apply this add-on to a list.


I am going to guess from the presence of an ID field and from the error message that your sheet is linked to a form. Duplicate the sheet and perform the desired operations on the duplicate. Spreadsheets containing form responses don’t currently allow for filtering, column shifting, or other such changes. The reason for these restrictions is that changes ...


It has been indicated on the Google Product Forum that if you were to put leading 0's as placeholders it will sort properly. So in @Gavin Hudson's example if you created files with names starting: 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11 It would sort properly. In the general case, you need to find out the order of magnitude of how many files you have ...

Only top voted, non community-wiki answers of a minimum length are eligible