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

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:

*To find out what plan, license type, or access you have, contact your Workfront administrator.

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, such as Status Timestamp Custom Field.

  4. Click Done, then 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.

On this page