I have seen similar requests in the community discussions, but they all seem to have very detailed needs, and would require a very tailored solution. I believe a lot of users, in general, would benefit GREATLY with a simple "custom view" option on the sheet level. Nothing special, just a simple way to view and save different sets of column views. No rearranging, no filtering, no conditional formatting, just different column views (although these would be a nice add-on in future releases
but one step at a time).
This would help teams with large spreadsheets, with multiple users working on different parts of the spreadsheet, the ability to recall hidden/unhidden columns they need, quickly and easily without affecting other team members, and still benefit from the use of hierachy, notifications, and alerts.
If you agree, please reply, and +1 this post.