Summary of Project and Phase Allocation % for each resource
I am trying to create a section at the top of the projects Gantt that shows the total allocation % for each resource in each project phase and in the project overall. I need this to not double count in resource manager, but just roll up each resource's allocation % from a Phase and the project in total. I've tried adding helper columns and summary fields, but the formula always shows that it's BLOCKED. This is the formula that I've been trying to use for the total project allocation %
=SUMIF([Assigned To]:[Assigned To], "Resource Name", [Allocation%]:[Allocation%])
Answers
-
Hi @jpflueger,
I recommend double checking your "Assigned To" column and "Allocation%" column and making sure that none of the rows have any errors such as "#UNPARSABLE" or "#INVALID".
Can you add a screenshot of the columns in your sheet? It'll make it a little easier for me to wrap my head around some other potential formulas that we can use.
Thanks!
SSFeatures - The browser extension that adds more features into SmartSheet.
- Automatic sorting, sorting with filters, saving sort settings
- Spell checking
- Report PDF generator that supports grouped and summarized reports
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!