Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,456,929
Community Members
 
Community Events
176
Community Groups

is there an easy way to include "time to resolved" or "days until done" in a jira for sheets export?

kim I'm New Here Aug 03, 2022

I have a jira for sheets export where I can capture a create date and last updated, but I cannot get the "time to resolved" in an accurate way that takes account of weekends. Is there a way to export the SLA time stamps or something similar to use as a reference point instead of the "last updated" date? Thanks!

1 answer

Hi, @kim 

I would recommend you try to add columns like "Time to resolved" to export the report where they will be included. I'll show you now what I mean :)

I will show it on the example of SLA Time and Report for Jira add-on. I have experience of doing like this in this plugin and hope it'll help you too.

So, here we can add Custom fields that will be added to your Jira issues. So if you need to monitor "Time to resolved", then you can add such "Time stamp" and "Label" custom fields:
(You can also add additional Cuestom fields, if you need. Personally I would also add a "Reminder" field because I prefer to get reminders a few days before the due date, as sometimes I forget about the task I have to do by the day X)

fields_.pngThen choose a date which should be a "Time to resolved" date & time:

CFS_.png


After that configure the SLA Configuration, choose Start and Stop conditions, activate Custom Fields and choose some automated actions.

For example, I want the "Time to resolved" date to be August 22, 10:00 PM. But I would also like to set up sending notifications before this date, and a few days before so not to forget about it and not to miss this time goal, so I can do like this:

goals _.png

And to monitor how everything is going and if your "Time to resolve" goal is met, you can choose what columns you want to be shown in the reports:

columns__.png

tts.png

 

And then download the report in Excel or CSV format

export_.png

reports_.png

Hope it helps.

And let me know if you need help of info! This add-on was created by my team, so we will be glad to tell you more how to work with SLA Time and Report for Jira add-on.

Have an amazing day!

Regards,
Olha

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS

Atlassian Community Events