+1(514) 937-9445 or Toll-free (Canada & US) +1 (888) 947-9445

Small hint to the spreadsheet tracker maintainers

sistemc

Hero Member
Feb 2, 2014
514
178
Hi maintainers,

kudos to you for spending your time maintaining&updating the google spreadsheet tracker. I used the 2017 version a lot while waiting during my citizenship application procedure - especially for sorting on different columns - like location, or dates.

But when I open the 2018 spreadsheet recently I find that some new added/split fields top left renders column sorting useless.

You might consider removing or moving away the cell A2.
 

Goku

VIP Member
Jan 13, 2014
4,082
730
Category........
Hi maintainers,

kudos to you for spending your time maintaining&updating the google spreadsheet tracker. I used the 2017 version a lot while waiting during my citizenship application procedure - especially for sorting on different columns - like location, or dates.

But when I open the 2018 spreadsheet recently I find that some new added/split fields top left renders column sorting useless.

You might consider removing or moving away the cell A2.
@Chi2Van
 

DANBR86

Full Member
May 19, 2018
35
19
If i have understand the subject, sorting doesn't depends of a ''header'' in the top of spreadsheet.Entering in 2018 applicants spreadsheet you can select the entire line you want to produce a sorting and use the features/results will be the same.
 

sistemc

Hero Member
Feb 2, 2014
514
178
If i have understand the subject, sorting doesn't depends of a ''header'' in the top of spreadsheet.Entering in 2018 applicants spreadsheet you can select the entire line you want to produce a sorting and use the features/results will be the same.
As I mentioned, sorting is done by columns, not lines. In 2017 spreadsheet single or multi column sorting worked as expected. In 2018 version of the spreadsheet cell A2 (HTTP link to this forum) brakes the sorting.
 

DANBR86

Full Member
May 19, 2018
35
19
Ok, i understand your point, trying sorting with the hyperlink in row 2 is not possible. Have you tried to download to excel ? What is the need to sorting these data?
Cheers.