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

Some value in exported data is not visible due to Error

In JIRA Service Management while i am exporting data Time to resolution field found below error. It is auto generated file and we don't know from where this error came 

time to resolution error.PNG

1 answer

0 votes

It's a long story behind it, but the answer here is "do not export the 'time in status' field". 

It is not really a field, and it's certainly not one intended for humans to read.  The data in it is encoded in a way that

  • Makes it look like nonsense to humans
  • Is readable by the code in Jira that knows how to show it to humans in a readable format
  • Often contains values that make it look like a (broken) formula, reference or function to a spreadsheet, hence the error message you're fetting

@Nic Brough _Adaptavist_ Thanks but we need this field in export

Your options are:

  • Tell the column in the spreadsheet that the content is to be interpreted as plain text (which will be useless to you as it's not human readable)
  • Do some coding in the spreadsheet so that it understands how to read and display the data
  • Write an app for Jira that reads the field and shows another field that can be exported as something your spreadsheet can show and change your export to read that field instead

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira Service Management

Why upgrade to Jira Service Management Premium?

We often have questions from folks using Jira Service Management about the benefits to using Premium. Check out this video to learn how you can unlock even more value in our Premium plan.  &nb...

227 views 1 6
Read article

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