Overallocated (assignment field)

Data Type    Yes/No

Entry Type    Calculated

Description    The Overallocated field indicates whether a resource is assigned to more work on a specific task than can be done within the resource's normal working capacity.

How Calculated    If an assignment is overallocated, the Overallocated field contains Yes. An assignment is overallocated if the assignment work by itself causes the resource to be overallocated.

Best Uses    Add the Overallocated field to the sheet portion of the Task Usage or Resource Usage view when you want to review or filter for the assigned resources that have more work on specific assignments than they can do within their normal working capacity. You can then take action by assigning other resources or adding overtime.

Example    Sean's normal working day is an 8-hour day. If you assign Sean to an assignment that requires 10 hours of work in a single day, the Overallocated field for this assignment is set to Yes.

Remarks    You can also see whether an individual resource is overallocated by viewing the resource in the Resource Graph view.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.