Ticket Duration - Jira for Google Sheets

Nicolò Vitelli

Hi, I installed the Jira for Google Sheets add-on to copy my Tickets to a Google Sheet.

There are the Summary, Ticket ID, Assignee, Reporter, and the other interesting fields.

But, I wanna know how to include a Column that shows the Ticket Duration (from when they have been opened to when they have been closed)

Is this possible? Thank you

Alex Koxaras -Relational-

Hi @Nicolò Vitelli

As Jack already told you, this can be done manually, since there isn't such a field by default in Jira. And for a good reason, since there are many parameters to think about, such as time in statuses, closed and re-opened etc.

Of course you could do the calculation manually, but I'm the number you will get will not represent the precise amount if time that the issue was opened.