nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How can I make a custom calculated field for number of days since created date.

Zaldy Parian

I wanted to create a custom field that will calculate the number of days outstanding since the issue/bug was created. And if possible, excluding the weekends and holidays. This is important in our company as we check the turnaround time of the issue/bug closure time with the standard level of agreement (SLA).

Accepted answers

All comments

Alex Christensen

If you aren't using Jira Service Desk, this is something built-in in JSD, so if that's a possible option for you to evaluate, I'd definitely consider it. More details about Service Desk here.

Other than Jira Service Desk, there's no way to do this by default. You will need an add-on to achieve this. Some suggestions I have if you're on Jira Server (I don't know any for Jira Cloud off the top of my head):

Jira Misc Custom Fields introduces a Calculated Number or Text Field type. You can write some code to return what you need.
ScriptRunner allows you to create scripted fields, so you could create a script that returns what you need, as well.

Zaldy Parian

I guess I'll have to do extract to excel for now, and add a formula to calculate the elapsed time. :-(

Tuncay Senturk _Snapbytes_

You can use Enhancer Plugin for Jira

It has a couple of Time custom fields.

Time Between custom field calculates time between two status, and display the result according to the selected calendar. However, it only displays value when the issue arrives to final status
Time Tracker custom field can calculate time like Time Between, but it does not wait for final status. Also it can sum time in subtasks as well.

Best

Faisal Shamim_4mw8qw

How can I do this in JSD @Alex Christensen , I am using JSD cloud and want to know if its possible to do some calculation on custom field ? Thanks in advance

Aron Gombas _Midori_

@Zaldy Parian if the Excel route is an option for you, then check out this article (it saves you manually creating the formula every time).

This example has 2 fields in the right that calculate the duration between 2 events, so you can use this as inspiration:

jira-issues-with-custom-calculated-fields

Tuncay Senturk _Snapbytes_

Hi @Aron Gombas _Midori_

As far as I know, you're violating "No necroposting" rule which is mentioned here: https://community.atlassian.com/t5/Marketplace-Apps-Integrations/Atlassian-Community-online-guidelines-for-Marketplace-vendors/ba-p/689723

Pronto Software

Hi @Faisal Shamim

I can't see any special JSD Custom Field types that include calculation capability.

As far as I can work out the JSD built-in capability could be achieved with Project Automation. Note: the calculation would occur after the customer creates the request.

There are a number of add-on apps that provide this capability, we use Jira Misc Workflow Extensions and Extensions for JSD.

Good luck,

Peter Q

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

custom-field

jira

calculated-field