Tag Info

Hot answers tagged

14

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


9

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

The biggest disappointment many people have in Gmail is when we try to sort messages. There was never any way to sort by anything. It's always default to descending date. If you need to browse your mailbox in a different way, get IMAP and an email client. While I kinda agree with this approach, sometimes I do miss at least being able to sort dates in ...


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

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

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

Gmail uses labels, they don't use folders, you'll need a different email program for that. The Move To dropdown, is just a combination of labeling and archiving. Archiving in Gmail, just hides your email by removing the inbox system label.


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

Unfortunately you can't. You can sort your photos only by Name, Date, or Size. Source: Picasa and Picasa Web Albums Help


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

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 ;)


1

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.



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