Hot answers tagged

14

Not yet. This feature is still on suggest list of feature for Gmail. Suggest a feature for Gmail


14

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 ...


9

Using to Google command line tools seems to return results in order of filing if no other sort method is set.


5

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


4

Click on View all (in your case) or ...more Click on 1-50 of XXX Click on Oldest In some cases it doesn't work and I don't know why. Also, it doesn't work in Priority Inbox view, you have to go to each category - Important, Starred, Everything else - to be able to sort by Newest/Oldest.


4

If you really need to do this, one way is to download your messages into Thunderbird, for example, and sort them there. Google has a philosophical objection to sorting (except for reverse chronological order by last activity, of course) and is unlikely to implement this anytime soon.


4

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 ...


4

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 ...


3

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!


3

This is not currently possible but there are a lot of comments and votes for this feature here: https://trello.com/c/VWrInnH8


3

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 "...


3

Managing expectations Scripts cannot intercept a user's click on column name. This action will always invoke built-in search. So, if you want users to sort by clicking a column, you need a separate column for sorting. With a separate column You don't need a complex formula with IFs to remove articles or other words: a regular expression can be used to ...


2

You can get the top 50: Votes by males Note: To get to this page, I clicked on the Tops at the Box Office link and chose Votes by Gender on the left side.


2

The answer is you cannot. Geni is still working to improve their album organizing features and several options such as the one I was asking about (and others such as moving images from one page to another page inside an album) are not yet available. I hope they'll be soon because I find these features missing a serious flaw.


2

There are some hacks to do this kind of thing here...


2

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 ...


2

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


2

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


2

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 ...


2

Filter view One tool that can be used for this purpose is a filter view. Create a view in which the responses are sorted by column A in reverse order (Z to A). Copy the URL of this view and share it with the users who are supposed to view the response sheet. A drawback of filter view is that if a new response arrives while a user is looking at the ...


2

This duplicates data (or since the source for the query is itself imported, even triplicates) but does seem to provide automatic resorting as data input changes: =query(A1:B5,"Select * order by B desc")


2

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 ...


2

An alternative regarding blanks sinking to the bottom is to use QUERY, where they float to the top. So starting with: this formula in D1: =query(A1:A3,"Select * order by A") will return a blank in D1, i in D2 and x in D3.


2

I suggest a helper column (ColumnC) populated in C2 with: =value(substitute(mid(A2,find(" ",A2)+1,2),"/","")) copied down to suit, then sorted by ColumnC not including header. MID take the first and second characters after the first space (located with FIND) and since one of those might be /, SUBSTITUTE replaces any / with nothing. VALUE then ...


2

Key for the sort is the notation of the digits in the text (String #). These are sorted alphanumerically, meaning that 9 is higher than 25 when sorting descendingly. This can be resolved by squeezing in a zero to all digits ranging from 1 to 9. See formula I constructed. Formula =SORT( // range UNIQUE( // range ...


2

Database Software I think Google Sheets can do this but do consider whether to use proper database software (Google for "database software"). Those will handle tables of data with more/easier high-level control. They won't have cell formulas that can get inconsistent between rows, or cells accidentally added outside of a desired range. There are many ...


2

Extracting the date with regex, and converting the result with datevalue isn't that much work: =datevalue(regexreplace(A2, "^\w* (\d+) (\w+) (\d+).*", "$1-$2-$3")) Then sort by this new column. Explanation: the three captured groups in the regex are the year, month, and day. The whole string gets replaced by year-month-day, which isn't quite ISO ...


2

Short answer The desired result could be obtained without scripting and this is recommended for cases where number of cells is small, especially if the OP don't know about scripting. To do so, Add auxiliary columns for each sorting criteria Then use the SORT() or QUERY() functions. Extended answer Google Sheets has some additional functions regarding ...


1

The formula =TRANSPOSE(QUERY(A:A, "select A where A contains '1.'")) entered in C2, would fill C2, D2, E2 with 1.1, 1.2, 1.3, as in your example. You can also include a formula within the query so it's applicable to every row in your example: =TRANSPOSE(QUERY(A:A, "select A where A contains '"&ROW()-1&".'"))


1

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.



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