View: task with All Dates variance

Last update: Tue Nov 07 2023 00:00:00 GMT+0000 (Coordinated Universal Time)

Topics:
Reports and Dashboards

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.

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*

Request to modify a view

Plan 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

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

Go to a list of tasks.
From the View drop-down menu, select New View.
In the Column Preview area, eliminate all columns except for one.
Click the header of the remaining column, then click Switch to Text Mode.
Mouse over the text mode area, and click Click to edit text.

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

Click Save View.

recommendation-more-help

5f00cc6b-2202-40d6-bcd0-3ee0c2316b43