Hey everyone,
I've gathered all opinions about row and column order in the spreadsheet (I hope I didn't miss anyone).
Here they are.
Rows:
obryan20, leave as is.
Achiever 99, same as FSW13, which, if I understood correctly, means leave as is, but also sort by Time Received in groups of apps with the same Application Status, NOC and Received Date.
june17th2174, if I understood correctly, the proposed order is very similar to FSW13 as well.
binuky, sort by Received Date and then by Received time.
It looks like we have a majority of people, who prefer the following sorting order: App Status, then NOC, then App.Received Date, then App.Received Time (it's how it's done in FSW13 as well).
I've implemented that missing part - sorting by Received Time when App.Status, NOC and Received Date are the same - so you can check it in the spreadsheet now.
For all those in a minority, there are sorting filter views, which allow to set different sorting order: Data->Filter Views
binuky, there's a "Sort by application received date and time" filter which does exactly what you've been asking for.
If someone has additional suggestions for filter views that might be useful for other people as well, please make a request here in the forums and I'll try to configure it. Just please keep in mind that amount of filter views is limited by the screen size, as the list does not scroll, which is a Google Spreadsheets bug.
Columns:
balars4, chronological order.
gs123, chronological order.
Wash an, chronological order.
obryan20, leave as is OR move Sent Date to the right of Days Since App Received; leave Receiving time as is OR move to the right of "Application Received".
Achiever 99, same as FSW13, which means leave as is, but freeze the following columns: Name, NOC, VO, App.Received, Days Since App Filed.
With columns it's a bit more difficult. I've honestly tried to put the columns in a chronological order, but it doesn't look good when you can't always see Application Received date and Days Since App.Received, so I've decided to settle down on the FSW13 order and to freeze the most important columns, so that they're always visible.
Please check the spreadsheet. It's really difficult to suit everyone, but I hope the FSW13 solution is proven enough to be used.
I've also added Days in Transit column, it was requested and it looks like it's helpful for some people