Welcome!

Resource Allocation Filter by Sheet

I understand how to use the Resource View for resource allocation and view it across Groups/Projects/Users. I am interested to know if I can "turn off" the allocation % view of certain sheets. The reason I am interested in this is so I can set up a "master sheet" to manage resource allocation for different projects, but other managers are sharing these resources and utilizing at a more granular level with their project sheets. So, if I could still leave resource allocation in tact for the other managers to utilize but have my own view based on designated sheets that would be ideal. I cannot seem to find a way to do this.

Find more posts tagged with

Comments

Andrée Starå

Hi,

You can select which users, groups or projects you want to include in the specific Resource View. You choose these option in the particular resource view > Edit > Select type in the drop-down and decide what to include.

Would that work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Isaac Jose

Hello,

Thanks for your post! It sounds like you want to enable an isolated sheet-level Resource View and Allocation % that does not affect the Resource View and Allocation % displayed on the other project sheets in your account that these resources are allocated on. There isn't currently a way to ensure that your Resource Allocation % does not display on the other sheets in your account, but I've let the product team know about your request and they will consider it for potential future development. You can also click on the Submit Product Enhancement Request quick link to the right.

In addition to Andrée's suggestion above, I may also recommend disabling Resource Management in the sheet by navigating to Gantt View > Project Settings (Gear Icon) > Resource Management and un-checking the resource checkbox. When this checkbox is not checked, the sheet is not included in Resource calculations. When you want to view it in Resource Views, enable Resource Management and observe the view, then disable Resource Management when complete.

Resource Management and Allocation https://help.smartsheet.com/articles/1346969
Project Management Tutorial https://help.smartsheet.com/learning-track/smartsheet-advanced/project-management-tutorial

I hope this helps!

Isaac J

Smartsheet Support

Sign in to join the conversation!

Quick Links

Trending discussions

I am getting an error message when attempting to export to excel
I am attempted to export to excel. I have two different smartsheet documents to export. One of them exported to excel fine, but not the other. This happened a few weeks ago. I make sure all columns were the correct size & no cells were hidden. "We have found a problem with (file) Do you want us to try and recover as much…
Need Help w/ Report View - Nothing Is Showing
Hello Smartsheet Community, I need some help with a report that I created and shared with a customer. The customer is not seeing any of the information that is pulling into the report. See screen shot below that the customer texted me. I do have the report filter only showing the customer their product pulling from our…
How can I hard code a cell based on a trigger?
BLUF: When I create an Invoice, I need the cell-link to my live price data to be severed. I currently have a Price sheet for my products that is updated frequently. I use Control Center to create Projects, which includes an Invoice sheet. I have a dropdown on my invoice sheet to select a product, and then I use Index…