Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

The Assignment fields indicate whether the row is an assignment row, rather than a task or resource row.

There are several categories of Assignment fields.

Data Type    Yes/No

Assignment (task field)

Entry Type    Calculated

How Calculated    If the row is an assignment row, the Assignment field contains Yes. If not, the Assignment field contains No. The Assignment field for tasks always contains No.

Best Uses    The Task Usage view displays assignment rows, which indicate which resources are assigned to the task. Add the Assignment field to the sheet portion of the Task Usage view when you want to display whether the field is an assignment row. Filter for the Assignment field when you want to see only assignment rows (Assignment = Yes), or when you want to exclude assignment rows (Assignment = No).

Example    In the Task Usage view, you want to see only assignment rows for assignments that have more than 80 hours of work. In the Filter Definition dialog box, you filter for all Assignment fields equal to Yes together with Work fields that have values greater than 80 hours.

Assignment (resource field)

Entry Type    Calculated

How Calculated    If the row is an assignment row, the Assignment field contains Yes. If not, the Assignment field contains No. The Assignment field for resources always contains No.

Best Uses    The Resource Usage view displays assignment rows, which indicate which tasks are assigned to the resource. Add the Assignment field to the sheet portion of the Resource Usage view when you want to display whether the field is an assignment row. Filter for the Assignment field when you want to see only assignment rows (Assignment = Yes), or when you want to exclude assignment rows (Assignment = No).

Example    In the Resource Usage view, you want to see only assignment rows for assignments that have more than 80 hours of work. In the Filter Definition dialog box, you filter for all Assignment fields equal to Yes together with Work fields that have values greater than 80 hours.

Assignment (assignment field)

Entry Type    Calculated

How Calculated    If the row is an assignment row, the Assignment field contains Yes. If not, the Assignment field contains No. The Assignment field for assignments always contains Yes.

Best Uses    The Task Usage and Resource Usage views display assignment rows. In the Task Usage view, the assignment rows indicate which resources are assigned to the task. In the Resource Usage view, the assignment rows indicate which tasks are assigned to the resource. Add the Assignment field to the sheet portion of the Task Usage or Resource Usage view when you want to display whether the row is an assignment row. Filter for the Assignment field when you want to see only assignment rows (Assignment = Yes), or when you want to exclude assignment rows (Assignment = No).

Example    In the Task Usage view, you want to see only assignment rows for assignments that have more than 80 hours of work. In the Filter Definition dialog box, you filter for all Assignment fields equal to Yes together with Work fields that have values greater than 80 hours.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×