Hot answers tagged sorting
3
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
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.
3
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 ...
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
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
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 ...
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.
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
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.
Only top voted, non community-wiki answers of a minimum length are eligible
