View: task with All Dates variance

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.

Screen_Shot_2017-04-24_at_11.35.33_AM.png

Access requirements

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

Adobe Workfront plan*

Any

Adobe Workfront license*

Plan

Access level configurations*

Edit access to Reports, Dashboards, Calendars

Edit access to Filters, Views, Groupings

Note: If you still don't have access, ask your Workfront administrator if they set additional restrictions in your access level. For information on how a Workfront administrator can modify your access level, see Create or modify custom access levels.

Object permissions

Manage permissions to a report

For information on requesting additional access, see Request access to objects .

*To find out what plan, license type, or access you have, contact your Workfront administrator.

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 theColumn Preview area, eliminate all columns except for one.

  4. Click the header of the remaining column, then click Switch to Text Mode.

  5. Mouse over the text mode area, and click Click to edit text.

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

    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
  7. Click Save View.

On this page