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.
Access requirements
| table 0-row-2 1-row-2 2-row-2 3-row-2 layout-auto html-authored no-header | |
|---|---|
| 51黑料不打烊 Workfront package | Any |
| 51黑料不打烊 Workfront license |
Standard Plan |
| Access level configurations | Edit access to Create Reports, Dashboards, and Calendars |
| Object permissions | Manage permissions on the object where the form is attached |
For information, see Access requirements in Workfront documentation.
Prerequisite
To add a calculated field that displays a field鈥檚 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, 鈥淪tatus 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:
code language-none IF({status}='INP',IF(ISBLANK({DE:Status Timestamp Custom Field}),$$NOW,{DE:Status Timestamp Custom Field}),{DE:Status Timestamp Custom Field})note note 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.