Can anyone help? I have a huge sheet with lots of filters and groups. Does anyone know if a way I can great views with certain groups expanded and others collasped that doesnt affect what other users view? in other words I want to expand certain groups but if anyone else is in the sheet they may want them collapsed, if that makes sense!
In Google Sheets, almost all view options are shared in real time between all users, which means that you cannot use grouped or hidden rows or columns without having other simultaneous users experience the same changes.
The only exception is filter views that let you and other users decide which rows to show at a time independently of each other, all without disturbing each other. Filter views also let you sort data in the view, without changing the storage order of rows. Filter views are different from regular filters.
You can save filter views and give them descriptive names. For additional ease of use, you can insert links in the frozen section of the sheet to easily switch between filter views, instead of having to go to Data > Filter views to switch. See the Filter views example spreadsheet for an illustration.