Skip to main content

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

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}


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!


Hi again @kuovonne ,

 

I cant get passed this step in the autimation:

 


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.


thanks @kuovonne for your help. I not got it figure out. 


Reply