Help with project metric and resource setup
we are not using Resource Management because it is way too manual of a workflow to manage. Instead I am trying to replicate some level of a resource map by doing the following:
there is 4 stage gates that are the primary workload impact for various teams with a specific Start/End for each stage.
Team 1 = Stage 1, Stage 2
Team 2 = Stage 3
Team 3 = Stage 4
Team 5 = Stage 2, Stage 5
SIDE QUESTION: Is there a way to have summary rollups in SCC create multiple line items per project? This way I can have 5 line items for this project, each line item being each of the 5 stage gates sharing the same Start/End columns? This would allow me to see each stage on the same chart and use filters to view team impacts? I can not use "copy/move row" since the dates will fluctuate as development goes on.
Assuming my side question is impossible, i am planning on setting up 5 separate summary sheets so that each one represents the 5 stage gates with their start/end dates and allocations. This way we can filter for specific teams or team members to see a gannt view of exactly what projects they are working on.
QUESTION: Is it possible to use a split gantt view in a report? This would allow us to join the 5 different summaries into a single report, using conditional formatting on the individual sheets to color code the stage gates, and then sort/summarize in the report to give us a great visual of workload impact with ability to filter for time of year and/or team/member. If not, is there any way to do what im trying to do in a Dynamic View or Advanced Calendar View?