Add Row/Column Groups to Proton Sheets
I track many things in my spreadsheets and grouping is a lifesaver. When I decide to track the TV series that I have watched by Season and suddenly there are 1000 rows in my spreadsheet, it would be almost impossible without grouping together first alphabetically and then by show as a secondary/subgroup. This makes it much easier to find what I am looking for and not be bombarded with however many rows in each spreadsheet.
This is one of the two main things keeping me with google sheets at the moment and I would love to fully switch over once Sheets here get some good UI/Quality of Life updates!
Anime Fan
shared this idea
-
Bit Of A Tinkerer
commented
On the off chance anyone reading this is not familiar with what grouping rows/ columns mean, in other spreadsheet apps (eg Google Sheets), you often have the ability to group rows or columns. These grouped rows/ columns will then have a + or - symbol next to them, allowing you to quickly hide/ show them within the sheet. As OP mentioned, this is particularly useful when organising large thematically-linked datasets or, in my case, when handling line items that must be on the sheet 100% of the time but is only used by 5% of the people.
To see how this works, you can reproduce this in other spreadsheet apps like Google Sheets: highlight a bunch of rows or columns > right click > (Google Sheets) View more row actions > Group rows *** - yyy. As mentioned, after grouping them, you should see a + or - icon next to them. By toggling them on/off, you can easily hide or show groups of rows/ columns.
I appreciate that this is more of a niche feature but hopefully as Proton Sheets continues to develop, the devs will be able to find time to fit this highly useful tool into the programme :)
-
Cody Terra commented
This is absolutely vital to the way I use spreadsheets. I considered separating my data into different tabs but that unfortunately isn't really helpful for the way I need to reference groups of data on my sheet. Column grouping is essential to me!