Hot answers tagged

14

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


13

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

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

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


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

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

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

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

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


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.


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



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