1 sheet multiple purposes?
This one has me stumped. My question: How can I use 1 sheet for input and "what if" scenarios?
Use case: My users go into the sheet (via a dashboard) and update a few columns (dates, resources, status, and notes). This is best done in the Grid view with some filters applied. Next, they want to be able to see the Gannt view of the same data, HOWEVER, they want to pick and choose the other project team values for review/overlap, dependencies, etc
I thought I could teach them about filters, however, this will be tough as they will change everyone else's filter, etc. Ideally, I would like to have 4-5 columns and a Gannt view...but can I have multiple "views" for the SAME sheet? It looks like the URL stays the same and this isn't possible.
Is there a better way
to do this?
NOTE: Reports won't work as it would need to be interactive when they select other roles/tasks for comparison.