DocumentationWorkfrontWorkfront Guide

View: task with All Dates variance

Last update: Fri Nov 15 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • User

This task view is similar to the “All Dates” view provided with your Adobe Workfront account. This particular view includes Variance columns, which calculate the difference in days between the following dates:

  • Planned and Projected Start Dates
  • Planned and Actual Start Dates
  • Planned and Projected Completion Dates
  • Planned and Actual Completion Dates

This view represents an example of calculated columns, in which you can take the values from two different columns and connect them by a calculation to obtain a third value. In this case, you subtract date 1 from date 2.

For more information about using calculations in a View, see the Overview of common uses for Text Mode section in  Overview of common uses for Text Mode.

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:

table 0-row-2 1-row-2 2-row-2 3-row-2 layout-auto html-authored no-header
Adobe Workfront plan Any
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 permissions Manage permissions to a report

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

View tasks with All Dates variance

  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, then 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:

    code language-none 
    column.1.descriptionkey=name
column.1.link.linkproperty.0.name=ID
column.1.link.linkproperty.0.valuefield=ID
column.1.link.linkproperty.0.valueformat=int
column.1.link.lookup=link.view
column.1.link.valuefield=objCode
column.1.link.valueformat=val
column.1.linkedname=direct
column.1.listsort=string(name)
column.1.namekey=name.abbr
column.1.querysort=name
column.1.shortview=false
column.1.stretch=95
column.1.styledef.case.0.comparison.attribute=css
column.1.styledef.case.0.comparison.isrowcase=true
column.1.styledef.case.0.comparison.leftmethod=intAsInt(numberOfChildren)
column.1.styledef.case.0.comparison.lefttext=numberOfChildren
column.1.styledef.case.0.comparison.operator=gt
column.1.styledef.case.0.comparison.operatortype=int
column.1.styledef.case.0.comparison.righttext=0
column.1.styledef.case.0.comparison.trueproperty.0.name=fontstyle
column.1.styledef.case.0.comparison.trueproperty.0.value=bold
column.1.styledef.case.0.comparison.truetext=
column.1.styledef.case.0.comparison.usefield=false
column.1.valuefield=name
column.1.valueformat=HTML
column.1.width=150
column.2.descriptionkey=plannedstartdate
column.2.linkedname=direct
column.2.listsort=atDateAsAtDate(plannedStartDate)
column.2.namekey=plannedstartdate.abbr
column.2.querysort=plannedStartDate
column.2.shortview=false
column.2.stretch=0
column.2.valuefield=plannedStartDate
column.2.valueformat=atDate
column.2.width=75
column.3.descriptionkey=projectedstartdate
column.3.linkedname=direct
column.3.listsort=atDateAsAtDate(projectedStartDate)
column.3.namekey=projectedstartdate.abbr
column.3.querysort=projectedStartDate
column.3.shortview=false
column.3.stretch=0
column.3.valuefield=projectedStartDate
column.3.valueformat=atDate
column.3.width=75
column.4.descriptionkey=plannedstartdate
column.4.displayname=Projected Start Variance
column.4.linkedname=direct
column.4.listsort=atDateAsAtDate(plannedStartDate)
column.4.namekey=plannedstartdate.abbr
column.4.querysort=plannedStartDate
column.4.shortview=false
column.4.stretch=0
column.4.styledef.case.0.comparison.attribute=css
column.4.styledef.case.0.comparison.isrowcase=false
column.4.styledef.case.0.comparison.leftmethod=atDateAsAtDate(plannedStartDate)
column.4.styledef.case.0.comparison.lefttext=plannedStartDate
column.4.styledef.case.0.comparison.operator=notnull
column.4.styledef.case.0.comparison.operatortype=date
column.4.styledef.case.0.comparison.righttext=
column.4.styledef.case.0.comparison.trueproperty.0.name=bgcolor
column.4.styledef.case.0.comparison.trueproperty.0.value=E1E1E1
column.4.styledef.case.0.comparison.truetext=
column.4.styledef.case.0.comparison.usefield=false
column.4.valueexpression=ROUND(DATEDIFF({projectedStartDate},{plannedStartDate}))
column.4.valueformat=HTML
column.4.width=75
column.5.descriptionkey=plannedstartdate
column.5.linkedname=direct
column.5.listsort=atDateAsAtDate(plannedStartDate)
column.5.namekey=plannedstartdate.abbr
column.5.querysort=plannedStartDate
column.5.shortview=false
column.5.stretch=0
column.5.valuefield=plannedStartDate
column.5.valueformat=atDate
column.5.width=75
column.6.descriptionkey=actualstartdate
column.6.linkedname=direct
column.6.listsort=atDateAsAtDate(actualStartDate)
column.6.namekey=actualstartdate.abbr
column.6.querysort=actualStartDate
column.6.shortview=false
column.6.stretch=0
column.6.valuefield=actualStartDate
column.6.valueformat=atDate
column.6.width=75
column.7.descriptionkey=plannedstartdate
column.7.displayname=Actual Start Variance
column.7.linkedname=direct
column.7.listsort=atDateAsAtDate(plannedStartDate)
column.7.namekey=plannedstartdate.abbr
column.7.querysort=plannedStartDate
column.7.shortview=false
column.7.stretch=0
column.7.styledef.case.0.comparison.attribute=css
column.7.styledef.case.0.comparison.isrowcase=false
column.7.styledef.case.0.comparison.leftmethod=atDateAsAtDate(plannedStartDate)
column.7.styledef.case.0.comparison.lefttext=plannedStartDate
column.7.styledef.case.0.comparison.operator=notnull
column.7.styledef.case.0.comparison.operatortype=date
column.7.styledef.case.0.comparison.righttext=
column.7.styledef.case.0.comparison.trueproperty.0.name=bgcolor
column.7.styledef.case.0.comparison.trueproperty.0.value=E1E1E1
column.7.styledef.case.0.comparison.truetext=
column.7.styledef.case.0.comparison.usefield=false
column.7.valueexpression=ROUND(DATEDIFF({actualStartDate},{plannedStartDate}))
column.7.valueformat=HTML
column.7.width=75
column.8.descriptionkey=plannedcompletiondate
column.8.linkedname=direct
column.8.listsort=atDateAsAtDate(plannedCompletionDate)
column.8.namekey=plannedcompletiondate.abbr
column.8.querysort=plannedCompletionDate
column.8.shortview=false
column.8.stretch=0
column.8.valuefield=plannedCompletionDate
column.8.valueformat=atDate
column.8.width=75
column.9.descriptionkey=projectedcompletiondate
column.9.linkedname=direct
column.9.listsort=atDateAsAtDate(projectedCompletionDate)
column.9.namekey=projectedcompletiondate.abbr
column.9.querysort=projectedCompletionDate
column.9.shortview=false
column.9.stretch=0
column.9.valuefield=projectedCompletionDate
column.9.valueformat=atDate
column.9.width=75
column.10.descriptionkey=plannedcompletiondate
column.10.displayname=Projected Completion Variance
column.10.linkedname=direct
column.10.listsort=atDateAsAtDate(plannedCompletionDate)
column.10.namekey=plannedcompletiondate.abbr
column.10.querysort=plannedCompletionDate
column.10.shortview=false
column.10.stretch=0
column.10.styledef.case.0.comparison.attribute=css
column.10.styledef.case.0.comparison.isrowcase=false
column.10.styledef.case.0.comparison.leftmethod=atDateAsAtDate(plannedCompletionDate)
column.10.styledef.case.0.comparison.lefttext=plannedCompletionDate
column.10.styledef.case.0.comparison.operator=notnull
column.10.styledef.case.0.comparison.operatortype=date
column.10.styledef.case.0.comparison.righttext=
column.10.styledef.case.0.comparison.trueproperty.0.name=bgcolor
column.10.styledef.case.0.comparison.trueproperty.0.value=E1E1E1
column.10.styledef.case.0.comparison.truetext=
column.10.styledef.case.0.comparison.usefield=false
column.10.valueexpression=ROUND(DATEDIFF({projectedCompletionDate},{plannedCompletionDate}))
column.10.valueformat=HTML
column.10.width=75
column.11.descriptionkey=plannedcompletiondate
column.11.linkedname=direct
column.11.listsort=atDateAsAtDate(plannedCompletionDate)
column.11.namekey=plannedcompletiondate.abbr
column.11.querysort=plannedCompletionDate
column.11.shortview=false
column.11.stretch=0
column.11.valuefield=plannedCompletionDate
column.11.valueformat=atDate
column.11.width=75
column.12.descriptionkey=actualcompletiondate
column.12.linkedname=direct
column.12.listsort=atDateAsAtDate(actualCompletionDate)
column.12.namekey=actualcompletiondate.abbr
column.12.querysort=actualCompletionDate
column.12.shortview=false
column.12.stretch=0
column.12.valuefield=actualCompletionDate
column.12.valueformat=atDate
column.12.width=75
column.13.descriptionkey=plannedcompletiondate
column.13.displayname=Actual Completion Variance
column.13.linkedname=direct
column.13.listsort=atDateAsAtDate(plannedCompletionDate)
column.13.namekey=plannedcompletiondate.abbr
column.13.querysort=plannedCompletionDate
column.13.shortview=false
column.13.stretch=0
column.13.styledef.case.0.comparison.attribute=css
column.13.styledef.case.0.comparison.isrowcase=false
column.13.styledef.case.0.comparison.leftmethod=atDateAsAtDate(plannedCompletionDate)
column.13.styledef.case.0.comparison.lefttext=plannedCompletionDate
column.13.styledef.case.0.comparison.operator=notnull
column.13.styledef.case.0.comparison.operatortype=date
column.13.styledef.case.0.comparison.righttext=
column.13.styledef.case.0.comparison.trueproperty.0.name=bgcolor
column.13.styledef.case.0.comparison.trueproperty.0.value=E1E1E1
column.13.styledef.case.0.comparison.truetext=
column.13.styledef.case.0.comparison.usefield=false
column.13.valueexpression=ROUND(DATEDIFF({actualCompletionDate},{plannedCompletionDate}))
column.13.valueformat=HTML
column.13.width=75
row.0.styledef.applyallcases=true
row.0.styledef.case.0.comparison.attribute=css
row.0.styledef.case.0.comparison.isrowcase=true
row.0.styledef.case.0.comparison.leftmethod=intAsInt(numberOfChildren)
row.0.styledef.case.0.comparison.lefttext=numberOfChildren
row.0.styledef.case.0.comparison.operator=gt
row.0.styledef.case.0.comparison.operatortype=int
row.0.styledef.case.0.comparison.righttext=0
row.0.styledef.case.0.comparison.trueproperty.0.name=fontstyle
row.0.styledef.case.0.comparison.trueproperty.0.value=bold
row.0.styledef.case.0.comparison.truetext=
row.0.styledef.case.0.comparison.usefield=false

  6. Click Done > Save View.

recommendation-more-help
5f00cc6b-2202-40d6-bcd0-3ee0c2316b43