Tag Info

Hot answers tagged

14

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


10

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.


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


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

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


3

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


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

By default, your chat list will be sorted by the people with whom you communicate most often. However, you also have the option of changing to alphabetical sort order. In Gmail: Click Options from the bottom of your chat list. Under Show in chat list: click All contacts or Top 250. You can change this back to popularity by selecting Most Popular instead. ...


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

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.


1

If your sheet locale is Australia, your dates are dd/mmm/yyyy format order and you are using New Google Sheets the sorting should be 'sensible'.


1

I did a bit of experimenting and I found the extra rows didn't get added as long as I had two or more rows after the range being sorted.


1

Unfortunately, what you are asking for is not possible. GMail has no such feature.


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.


1

There are four ways for you to perform a sort. See list below in no particular order: First (sheet) Add the build-in filter function, by pressing the funnel and selecting the first row: Then select the green down arrow in columnA, followed by descending (Z --> A): Second (sheet) Use this formula, on another sheet, to perform the sort you want: ...


1

I've got a solution by creating three different scripts: auto-sorting table range a3:c16 columntosortby = 2 ; auto-sorting table range a3:c16 columntosortby = 2 and auto-sorting table range d18:f31 columntosortby = 5; auto-sorting table range a3:c16 columntosortby = 2 + auto-sorting table range d18:f31 columntosortby = 5 + table range g33:i46 ...


1

I will answer this question assuming that you're using outlook.com. There are two things that could be happening here: 1- Your emails are not sorted by date. To fix this, go to your inbox and sort the emails by Date as shown here. 2- Your emails may be getting grouped by conversation. When this happens, messages are not shown individually and they may ...


1

Unfortunately, reddit doesn't offer many sorting options. You are forced to use their algorithm of what is and is not considered "relevant." The number of comments on a post is a factor in the algorithms for hot and rising, but that's it. The only way to achieve what you are after is via a third-party service, and I am not aware of any designed for that ...


1

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: =SORT(ARRAYFORMULA(TEXT(MONTH(FILTER(A2:A;A2:A<>""));"00") & " - ...


1

I am fighting with the same problem, I think it is because the protected cells are set statically and not affected by the sort. The reason is that Google Spreadsheets do not allow the selection of multiple ranges with are not adjacent to each other. In other words, If you have a defined protected range in the Spreadsheet, it will always be the same rows and ...


1

UPDATE Changed the formula to accept the ampersand as well The following formula will create a sorted column: =SORT(ARRAYFORMULA(VALUE(INDEX(SPLIT(A:A;"-&"),0,0)))) See example file I've created: Sort-able text column


1

You can copy a checklist on a board (Open card, "Add Checklist...", "Copy Items From..."), but there is no option to copy across boards, sorry. You might try out the API if you want something custom like that. You can also copy boards ("Options" > "Copy Board..."), if that helps.


1

I was quite frustrated for this problem too. The only solution I found was to code a Greasemonkey (Firefox add-on) script to manipulate the YouTube interface. It works also on Chrome. Check this out: http://userscripts.org/scripts/show/123272 Enjoy ;)



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