View: Planned Hours vs. Actual Hours per assignment in a task view

Last update: November 5, 2024

CREATED FOR:

  • User

This task view displays the total Planned Hours of a task, the number of Planned Hours allocated to each assignee (when the task is assigned to multiple users), the total Actual Hours of the task, and the number of Actual Hours logged by each assignee.

multi_assignment_budget_vs_actual_for_tasks.png

Access requirements

Expand to view access requirements for the functionality in this article.

You must have the following access to perform the steps in this article:

Adobe Workfront planAny
Adobe Workfront license

Current:

  • Request to modify a view
  • Plan to modify a report

New:

  • Contributor to modify a view
  • Standard to modify a report
Access level configurations*

Edit access to Reports, Dashboards, Calendars to modify a report

Edit access to Filters, Views, Groupings to modify a view

Object permissionsManage permissions to a report

For more detail about the information in this table, see Access requirements in Workfront documentation.

View Planned Hours vs. Actual Hours per assignment in a task View

  1. Go to a list of tasks.

  2. From the View drop-down menu, select New View.

  3. In the Column Preview area, eliminate all columns except for one.

  4. Click the header of the remaining column and click Switch to Text Mode > Edit Text Mode.

  5. Remove the text you find in the Edit Text Mode box, and replace it with the following code:

    column.0.descriptionkey=name
column.0.isInlineEditable=false
column.0.link.linkproperty.0.name=ID
column.0.link.linkproperty.0.valuefield=ID
column.0.link.linkproperty.0.valueformat=int
column.0.link.lookup=link.view
column.0.link.valuefield=objCode
column.0.link.valueformat=val
column.0.linkedname=direct
column.0.listsort=string(name)
column.0.namekey=name.abbr
column.0.querysort=name
column.0.section=0
column.0.shortview=false
column.0.stretch=0
column.0.valuefield=name
column.0.valueformat=HTML
column.0.width=150
column.1.descriptionkey=workrequired
column.1.isInlineEditable=false
column.1.linkedname=direct
column.1.listsort=doubleAsDouble(workRequired)
column.1.namekey=workrequired.abbr
column.1.querysort=workRequired
column.1.section=0
column.1.shortview=false
column.1.stretch=0
column.1.valuefield=workFieldLong
column.1.valueformat=compound
column.1.viewalias=workrequired
column.1.width=100
column.2.listdelimiter=
column.2.listmethod=nested(assignments).lists
column.2.name=Wrk Assignment(s)
column.2.stretch=0
column.2.type=iterate
column.2.valueexpression=CONCAT(right(CONCAT('~~~',{assignmentPercent}),3),'% (', {workRequired}/60 ,' Hours) - ',{assignedTo}.{name})
column.2.valueformat=HTML
column.2.width=300
column.3.descriptionkey=actualworkrequired
column.3.isInlineEditable=false
column.3.linkedname=direct
column.3.listsort=intAsInt(actualWorkRequired)
column.3.namekey=actualworkrequired.abbr
column.3.querysort=actualWork
column.3.section=0
column.3.shortview=false
column.3.stretch=100
column.3.valuefield=actualWorkFieldLong
column.3.valueformat=compound
column.3.viewalias=actualworkrequired
column.3.width=100
column.4.listdelimiter=
column.4.listmethod=nested(hours).lists
column.4.name=Actual Hours
column.4.stretch=0
column.4.type=iterate
column.4.valueexpression=CONCAT('(', {hours} ,' Hours) - ',{owner}.{name})
column.4.valueformat=HTML
column.4.width=300

  6. Click Done > Save View.

Previous pageView: originating issue details for tasks and projects
Next pageView: predecessor details

Workfront