Hey everyone,
there were some requests to enable filters in the spreadsheet. As I wrote before, unfortunately, filters in the same implementation as they were in FSW 2013 spreadsheet can't be enabled, as Google has changed this functionality and it's not available in new Google Spreadsheets.
Though, there's a workaround solution. It's a bit more limited, as it does not allow everyone to set any kind of custom filters, but it allows admins to create predefined filters.
First I wanted to create one filter per each NOC and per each visa office, but it appears this list doesn't fit into a single screen and there's a bug from Google - this list does not scroll, so only about 20-25 filters can be configured in total.
I've grouped NOCs and visa offices by the amount of applications they get. Some of the most popular visa offices, like New Delhi, London, CPC-O and Singapore got their own filters. Others are grouped together. It's a workaround, but still it's better than nothing, right?
You can find these filters in the spreadsheet menu: Data -> Filter Views.
Another way to access it is to press a dropdown arrow next to the Filter button on the toolbar. The Filter button is disabled, but the dropdown arrow is accessible.
Hope this helps
