How to show resource allocation from multiple sheets including Leave calendar
I have just discovered Resource Views, which allows me to create a %Allocation column in my sheet and display %Allocation per Assigned users. I have two sheet which have set up the %Allocation, 1. "Pipeline" and 2. "Leave Calendar". However the resource allocation sheet in Resource views is only picking data from my Pipeline but not my leave Calendar. Can I make it pick up %allocation data across multiple sheets and consolidate it in the resource allocation sheet. From the image below you can see only the pipeline data being used.
The other anomaly I noticed was in my "Pipeline" sheet, under project settings/Resource management, I have three options (Disabled, Resource Management by Smartsheet and Legacy Resource management)
In my "Leave calendar" sheet, under project settings/Resource management, I only have two options. Im not sure why, and if this is somehow impacting the way that data is picked up by the Resource allocation sheet,
Any help or suggestions would be appreciated. Thanks
Answers
-
Legacy Resource Management is a legacy feature that is no longer being supported or updated by Smartsheet.
Is it possible that the second sheet without the Legacy selection is owned by someone in a different account? For example, a Pro Plan, or part of a plan that has not enabled Legacy Resource Management in their settings:
If you're looking for a way to track your allocation, I would suggest looking into Resource Management by Smartsheet instead. (This is the other option from that window). Here's more information:
Cheers,
Genevieve
