Calculated custom field example: display a Status timestamp in a custom form

Last update: October 23, 2024

CREATED FOR:

  • User

The following calculated field displays the date when the object status is marked as In Progress (INP.) You can use the same information for calculated custom fields for issues, tasks, or projects.

NOTE
If the status of the object changes to INP, then it changes to another status, then back to INP, Adobe Workfront captures only the timestamp of the first change to INP.

Access requirements

You must have the following:

Adobe Workfront plan*Any
Adobe Workfront license*Plan
Access level configurations*

Edit access to Create Reports, Dashboards, and Calendars

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 change your access level, see Create or modify custom access levels.

Object permissions

Manage permissions on the object where the form is attached

For information on requesting additional access, see Request access to objects.
For more information on permissions for dashboards, see Share reports, dashboards, and calendars.

Prerequisite

To add a calculated field that displays a field’s edit history to a custom form, you must first create the custom form.

Display a Status time stamp in a Custom Form

  1. Go to a custom form where you want to add the field.

  2. Click Calculated to add a calculated custom field to the form.

  3. Type a Label for the custom field. For example,“Status Timestamp Custom Field”.

  4. Click Save+Close.

  5. Re-open the custom form, then select the new Status Timestamp Custom Field on the form.

  6. In the Calculation box, copy and paste the following calculation for your custom field:

    IF({status}='INP',IF(ISBLANK({DE:Status Timestamp Custom Field}),$$NOW,{DE:Status Timestamp Custom Field}),{DE:Status Timestamp Custom Field})
    NOTE
    This calculation is identical for all objects and for all statuses. You must always use the three-letter key, and not the status name for the object status in this calculation.
    For more information about the keys for Statuses, see Create or edit a status.

  7. Click Save+Close.

    You can now report on the Status Timestamp Custom Field or use it in other calculations, in reports, or in custom fields.

More help on this topic

Previous pageCalculated custom field example: display the manager of an issue's creator on the issue custom form
Next pageCalculated custom field example: display a field's edit history

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

B2B Reimagined: Transforming Go-to-Market Strategies for Profitable Growth

Online | Strategy Keynote | General Audience

B2B brands are facing a digital revolution. Buyers expect hyper-relevant content and self-service, while internally AI is transforming...

Wed, Mar 19, 1:00 PM PDT (8: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