This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a plan with some tasks that have over-allocated resources assigned. It's indicated in the indicators column and is obvious anyway. I want to insert the over-allocated column and group on that, but it doesn't come up with yes for any of them. I can work around it, but why?
Microsoft project management software used to plan, manage, and communicate a project schedule and other information among workgroup members, project managers, and other stakeholders.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 92%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
Dale,
Thanks for jumping in. I won't bother tracking down the answer.
John
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(179.20000000000002, 17%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDH%3C/text%3E%3C/svg%3E)
All --
I can explain the oddities you are seeing. The Overallocated field only displays a Yes value when the resource is overallocated on that one task, such as when you assign the resource at a Units value of 200%, but their Max. Units value is only 100%. It DOES NOT display overallocations for a resource that is overallocated on parallel tasks. Because of this, the Overallocated column is practically useless. Hope this helps.
Trevor,
Well now, that's interesting. Before I responded I did a quick test on a client's file that had some overallocations. I did a group at Gantt Chart level and it appeared to work so I fired off a response. But. . .I didn't look close enough. When I look at that same file today I see only a few of the overallocated tasks have the overallocation flag, most do not. Once again, gremlins in the Outback. If I have some time, I'll see if I can figure out why.
John
John, are you sure it can be grouped in Gantt chart view? OK, it can be grouped but I just get No for everything.
Trevor,
Good question. Apparently the Overallocated field is an Assignment Resource field. . . well, sort of. It can be grouped in the Resource Usage view, not the Task Usage view. But, interestingly enough, it can also be grouped in a Gantt Chart view.
Go figure.
John