Resource View by Project
I wonder if anyone might be able to shed some light on an issue I'm experiencing. I'm a new Smartsheet user so I could well be doing something wrong or expecting Smartsheet to work in a way that it doesn't. I'll set out the issue below and if anyone can explain what I'm doing wrong, or if there is a different way to do this in Smartsheet I'd be grateful.
I'm trying to build a workload view using sheets and the Resource View, so we can schedule projects more effectively.
I've set up 2 sheets which are used as roadmaps for allocating work to people. One sheet holds project allocations and is also used as a project roadmap, the other sheet holds non-project allocations (line management % allocations, support % allocations etc.) that we don't want to show on the project roadmap.
In order to see people's total allocated workload based on the data held in these two sheets, I then created a Resource View and chose "By Project", carefully selecting only those two sheets that I want to pull in the allocation percentages from.
I was expecting that only the allocation percentages from those two sheets would be visible in the Resource View I've created, however allocation percentages from other sheets are also being pulled into the Resource View for named resources on those two sheets... this means that the overall allocations for each person in the Resource View reflect not just the roadmap allocations that I want, but also include other %age allocations from sheets that they have created!
To put this another way:
> Create Smartsheet called "Project Roadmap" and add a task called "Project X" for Bob that runs 1st July to 30th December, allocate him 50%
> Create Smartsheet called "Non-Project Roadmap" and add a task for Bob called "Line Management" that runs 1st July to 30th December, allocate him 50%
> Independently, Bob now creates his own plan for Project X, called "Bob's Project X Plan", allocating some tasks to himself.
> Create "Resource View" and select the "By Project" option, choosing only the "Project Roadmap" and "Non-Project Roadmap" sheets.
> The resource view shows allocations for Bob from all 3 sheets ("Project Roadmap", "Non-Project Roadmap", "Bob's Project X Plan"), rather than just the 2 sheets selected ("Project Roadmap", "Non-Project Roadmap").