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

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Structure formulas for 'spent time in status' column

Hello, I would like to create columns where I can show how much time was logged on an issue in different statuses (I would made as many columns as many statuses I would like to display) Is it possible to use formulas for this? I only could set columns which shows the time the issue spent in the statuses. I can't figure it out how should I set the formulas. Can you help me?

Thank you

3 answers

Hello @Hajnalka Farkas 

You can try Time in Status for Jira Cloud add-on, which shows how much time an issue has been spending in each status.  There are different columns for each status. 

You don't need any formulas or long configs. In a few clicks, you'll get the necessary data!

Also, you'll get data both in Graphs and Chart view.

I hope you find this helpful.

Best regards, Mariana.


Hi @Mariana_Pryshliak_Saasjet

Thank you for the reply. However we wanted to solve it within the structure plugin, but we will look into the plugin.

KR, Hajnalka

Hello @Hajnalka Farkas , Alessandro from ALM Works here.

The easiest way to sum the Duration of an Item, in one or more status using Structure, is through the "Time in Status..." column.

You can select Duration from one or a Sum of different Statuses.

This can also be achieved by using the "Formula..." option when adding new Columns as you mentioned. You can then set a "timeInStatus" variable in the formula field, save the formula and then update its definitions by:

  1. Click the "! timeInStatus" below the Formula field;
  2. Select "Time in Status" on the attributes DropDown (when you first select the drop-down, it works as a search field as well, so you can start Typing to make it easier to find the attribute);
  3. Once 'Time in Status' is selected, click on the Cog icon to the right of the attribute field to select which Status you would like to sum as a total.
    I.E.: You can select just "In Progress" or "In Progress" and "Done" to see the total time across both statuses.
  4. Change the Format field to "Duration" to make Structure calculate the formula as total of hours tracked.
  5. You can then customize other properties as you like, such as Sum a total of Hours based on subitems, if you want to show the total hours worked in all Stories under an epic or select "Work Time" in case your project hours are tracked according to Jira's "work hours per day" settings.
  6. Once done, just click outside the Column configuration panel and you should be already seeing the Duration of the selected status.

Please let me know if this helps! I look forward to hearing from you.

Warmest regards,
Alessandro C.
ALM Works.

Hello @Alessandro C_ _ALM Works_

Thank you for the reply. We will look and test to see if that’s what we’re looking for.

KR, Hajnalka

Hi @Hajnalka Farkas 

We have built an addon specifically for this need, as there is no easy way to extract this information out of the box.

You can try Issue Tracker for Jira 

It will provide you below charts on the issue screen itself.


Status Transition Graph.PNG

Status Transition_new.PNG

Hello @Rahul_RVS_Support ,

Thanks for posting the information, great to see the alternative option, and I have a quick ask for you for a follow-up.

Please review the partner guidelines here, and make sure to update your username according to your relationship as a vendor of the tool, noting:

Identify yourself as a partner: Make sure the user is aware you are affiliated with a partner company; for example, by placing the name of your company in your user name in {curly brackets} or -dashes- (note that regular brackets no longer work and have been automatically converted to dashes). If you are mentioning your own products or services, make sure you include wording to make it clear that you are affiliated with the company providing those products or services.


Thanks @Earl McCutcheon for notifying me. I have updated my username accordingly

Like Earl McCutcheon likes this

Hello @Rahul_RVS_Support 

Thank you for the answear. However we wanted to solve it within the structure plugin


Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira Software

Presenting the "Best of 2020" Jira Software roundup!

Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...

7,071 views 8 28
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you