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

Last update: October 23, 2024

Topics:
Reports and Dashboards

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

Go to a custom form where you want to add the field.
Click Calculated to add a calculated custom field to the form.
Type a Label for the custom field. For example,“Status Timestamp Custom Field”.
Click Save+Close.
Re-open the custom form, then select the new Status Timestamp Custom Field on the form.
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.
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.

recommendation-more-help