I have a shared spreadsheet to track multiple projects my team are working on. We have quite a few projects with a lot of grouped rows per project to track various stages/timelines and due dates. While working on these, my team may expand/collapse rows for their specific projects, but it forces the spreadsheet to jump on the other team members screens. Is there a way to isolate this so that I can have my team update the central spreadsheet without forcing other users to constantly be scrolling/searching for where they were?
