Explore recipe: Creating a ticket first reply date and time attribute

Return to top
Have more questions? Submit a request


  • Amanda Gunn

    Hi Eugene Orman

    How do you write this if you want the field to appear NULL or with some written text like "No first reply yet" when there has not been a first reply on the ticket? I created this attribute and used the date only formula, but for questions without a first response it is just putting in the date of when the ticket is created which is inaccurate.




  • Brett Bowser
    Zendesk Community Team

    Hey Amanda,

    I saw you already had a ticket open with our Customer Advocacy team regarding a similar query. Were you able to get your question answered from an Advocate?

    Let me know if there's anything else we can assist with.


  • Philip Crump

    Hi there,


    Thank you for the helpful metric. I am using the date formula that you supplied, and I have confirmed that it works on most of the data. However we have seen strange behaviour whereby it will actually show the first reply date as being in the future.

    In the table below you can see at the bottom that a ticket has been created on 3rd June, and yet it says the first reply was on the 3rd of August. Looking at the ticket itself I can see that it actually received it's first reply on the 6th July. I'm wondering how the calculation may have made this mistake?

    Another example is two tickets created on the 13th June, that the calculation says their first reply is on the 25th July (in the future). Yet one of these tickets was closed and merged with another, so never had a first reply, and the other was responded to on the 6th July. 


    Are you able to shed any light on why the calculation might be doing this?


    Thank you

  • Philip Crump

    I have found the issue! For tickets created with the exact same timestamp, the calculation seems to add their first reply times together. Do you think there is a way around this?

  • Devan - Community Manager
    Zendesk Community Team

    Hello Philip Crump,

    After looking into this and talking w/ a few of our experts on this subject, it does seem like some unexpected behavior is taking place. Right now, one of our specialists is looking into this issue and has reached to you via ticket. Once she has more information on this, she will reach out to you, but for now, we appreciate your patience with this snafu. 

    Best regards. 


Please sign in to leave a comment.

Powered by Zendesk