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
You must have the following:
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, such as Status Timestamp Custom Field.
-
Click Done, then 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.