View: display the result of a calculation between two fields in a column

Last update: November 4, 2024

CREATED FOR:

  • User

You can use text mode in a column to display a calculation between two fields.

For example, if you want to find out the number of week days that elapsed between two dates, you can use text mode syntax and data expressions to calculate this difference.
For example, you can calculate the week day difference between the Planned Completion Date and the Actual Completion Date of a task and display the result in a column.

You can use any other two dates in this calculation (Actual Start, Actual Completion, Projected Start, Projected Completion, etc).
For more information about calculated data expressions, see Overview of calculated data expressions.

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*

New:

  • Contributor to modify a filter

  • Standard to modify a report

Current:

  • Request to modify a filter

  • 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 filter

Object permissionsManage permissions to a report

*For information, see Access requirements in Workfront documentation.

Display the result of a calculation between two fields in a column

To add this column to a task view:

  1. Go to a list of tasks.

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

  3. Click Add Column, then Switch to Text Mode > Edit Text Mode.

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

    displayname=Week Day Difference
textmode=true
valueexpression=WEEKDAYDIFF({plannedCompletionDate},{actualCompletionDate})
valueformat=HTML

  5. (Optional) To aggregate the values displayed in the view in a grouping, follow the steps described in Grouping: display the result of aggregating multiple calculated values in a grouping.

  6. Click Done, then Save View.

More help on this topic

Previous pageView: calculate time and date differences
Next pageView: add a list of task successors in a column

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

Adobe’s Top 10 Generative AI Capabilities to Accelerate Your Content Supply Chain

Online | Session | General Audience

AI is rapidly transforming marketing content and customer experiences, but many companies face significant questions: How do I safely and...

Tue, Mar 18, 2:00 PM PDT (9:00 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

Register now