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%])

Find more posts tagged with

Sheet Summary

Resource Management

Allocation

Accepted answers

All comments

SSFeatures

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.