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

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • 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

Ability to dynamically update ticket status

Hello All,

Does jira provide a listener or plugin [for excel, google sheet or power point], to dynamically update the status of the ticket?

Thank you.

2 answers

1 accepted

4 votes
Answer accepted
G subramanyam Community Leader Feb 15, 2021

Hi @Murali Krishnan Nair welcome to the Atlassian Community forum and I wish you are staying safe.

There are number of plugins in the Atlassian Market place for excel integrations. Listed are few links you may check or try free versions for limited time.

https://workspace.google.com/marketplace/app/jira_cloud_for_sheets/1065669263016

https://automate.io/integration/google-sheets/jira

https://marketplace.atlassian.com/apps/1216655/excel-add-in-for-jira?hosting=cloud&tab=overview

https://marketplace.atlassian.com/apps/1216862/team-files-office-365-google-docs?hosting=cloud&tab=overview

If I response address your query, kindly click "accept answer" for the benefit of new members.

Thanks, @G subramanyam. I will explore these options.

Like G subramanyam likes this
1 vote
John Funk Community Leader Feb 15, 2021

Hi Murali,

Are you wanting Jira to update if the value in an external system such as Excel is updated?

If so, you will definitely need a plug in for that. Many only load data from Jira though and don't do an update back to Jira. Make sure you investigate that. 

Hello Frank, Correct a plug in is needed.

My usecase is:

I have the jira details with status in a tabular format (for reporting - whichever is viable powerpoint, excel or google doc). Rather than manually updating the ticket status for daily/weekly status reporting, I'm trying to see if there is a mechanism for the status to update itself listening to the jira ticket as a key.
Meanwhile, i will try to work around the "Jira Cloud for Sheets" provided in the previous comment.

Like G subramanyam likes this
John Funk Community Leader Feb 15, 2021

I am a little confused by the reply. Are you updating Jira and you want the Spreadsheet to be updated automatically? 

Or are you updating the Spreadsheet and you want Jira to be updated automatically? 

The spreadsheet updated automatically with the "current" status of the jira ticket.

John Funk Community Leader Feb 15, 2021

Automation for Jira can send Web Requests to a URL using Webhooks. I am not very familiar with doing that though so I don't know if that would apply or not. 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
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,193 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