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:

    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.

Previous pageView: submission path for issues
Next pageView: tasks impacted by schedule exceptions

Workfront


Learn: Automating Workflows with Workfront Fusion - Unique Use Cases in Action

Workfront

Tuesday, Mar 4, 6:00 PM UTC

Looking for creative ways to use Workfront Fusion to solve business challenges? Join Pan Shahbazian of Starbucks as she shares three unique use cases that can transform your workflows.

Register

The Perfect Blend: A New Era of Collaboration with AEM and Workfront

Adobe Customer Success Webinars

Wednesday, Apr 2, 5:00 PM UTC

Explore how Adobe Experience Manager and Workfront integrate to help teams move from ideation to delivery without the usual bottlenecks, ensuring content is organized, on-brand, and ready to go live faster.

Register

Driving Marketing Agility and Scale: Transforming your Content Supply Chain with AI

Online | Strategy Keynote | General Audience

Marketers everywhere are feeling the pressure to deliver impactful campaigns faster and at greater scale. This Strategy Keynote explores...

Tue, Mar 18, 2:30 PM PDT (9:30 PM UTC)

Register

A Proven Framework to Boost Campaign Creation Speed

Online | Session | General Audience

Disparate teams, messy workflows, and clunky approvals impede your content production speed and business impact. Stensul’s CEO, Noah...

Wed, Mar 19, 4:00 PM PDT (11:00 PM UTC)

Register

Connect with Experience League at Summit!

Get front-row access to top sessions, hands-on activities, and networking—wherever you are!

Learn more

Register to learn something new

WORKFRONT

Join Adobe product experts in live events where you will learn Adobe Workfront best practices, tips and tricks, and hear about the latest product features and updates.

Register