Just a heads up: On March 24, 2025, starting at 4:30pm CDT / 19:30 UTC, the site will be undergoing scheduled maintenance for a few hours. During this time, the site might be unavailable for a short while. Thanks for your patience.
×Hi everyone,
Here is my problem. I would like to automatically compare two things:
1. An estimated dev time in days (eg: 6)
I was planning on collecting 1. in a custom field which I could then automatically be exported to google sheets to do my analysis (thanks to a plug-in). The estimated dev time would be inputted manually so there are no issues with data collection here.
2. The actual dev time
This would be defined as the difference between the date at which development starts (issue = in progress) and the date at which it ends (issue = done). Both "in progress" and "done" are steps in our Jira workflow.
I was hoping to get both dates in two different custom fields to then export this information to google sheets to do my analysis (computing the actual dev time and then comparing the result with 1.)
If an issue changes to "in progress" tomorrow, how do I get tomorrow's date in a custom field?
Thanks in advance :)
PS: feel free to let me know if you know of a different approach to this problem!
Recommended Learning For You
Level up your skills with Atlassian learning
Learning Path
Become an effective Jira admin
Manage global settings and shared configurations called schemes to achieve goals more quickly.
Streamline Jira administration with effective governance
Improve how you administer and maintain Jira and minimize clutter for users and administrators.
Learning Path
Become an effective Jira software project admin
Set up software projects and configure tools and agile boards to meet your team's needs.