Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 22, 2024 07:05 AM - edited Mar 22, 2024 07:07 AM
Hi,
I want to calculate the time differentials between when a ticket gets assigned Status "DEV" to when it reaches Status "DONE"
The ticket is created before is assigned a status, so "date created" is not possible for me to use.
I'm thinking a calculated field with some formula setting the date when the ticket gets assigned Status "DEV" and Status "DONE"
Any kid of input would be really appriciated.
Thanks
Solved! Go to Solution.
Mar 25, 2024 02:34 PM
In your Update record action, it looks like you are putting the last modified time field value where the internal record ID of the triggering record goes. The {LTM - Status} value should go as the value for the {Time assigned} field.
This support article has more info on how to configure an update record action.
Mar 22, 2024 08:14 AM
It sounds like you have a single select field for {Status}. Try adding a few new fields and an automation.
- A Last Modified Time field that watches the {Status} field
- An editable date/time field for storing the {time assigned}
- A editable date/time field for storing the {time done}
- A formula field that calculates the difference between the {time done} and {time assigned}
- An automation that watches when the {Status} is updated. If the {Status} is assigned, copy the last modified time to the {time assigned}. If the status is done, copy the last modified time to {time done}
Mar 25, 2024 12:55 AM - edited Mar 25, 2024 12:56 AM
Thanks @kuovonne ! I have managed to do the first parts of your suggestions.
Could you walk me through the automation in detail a bit more? If possible sharing a screen shoot or two. I have not worked with automations before.
Thanks and much appreciated!
Mar 25, 2024 05:43 AM
Mar 25, 2024 02:34 PM
In your Update record action, it looks like you are putting the last modified time field value where the internal record ID of the triggering record goes. The {LTM - Status} value should go as the value for the {Time assigned} field.
This support article has more info on how to configure an update record action.
Apr 10, 2024 01:42 AM
thanks @kuovonne for your help. I not got it figure out.