Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Field history tracking

Mykhailo Goncharov
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 6, 2024

It is not so easy to understand what was changed in the particular field, even using history tab:

 

 

Is there any plugin to highlight changes like this:

 

 

3 answers

1 accepted

1 vote
Answer accepted
Yuliia_Borivets__SaaSJet_
Atlassian Partner
November 6, 2024 edited

Hi @Mykhailo Goncharov,

You can check Issue History for Jira app from my team. It provides a history of a single issue with highlighted (red and green) changes. It's easy to see what exactly was updated:

history of single issue jira.png

With additional filters, you can also get changes for a specific field like here: How to get history for the specific issue field in Jira

Getting a report of changes for all issues in your project is also possible.

You can book a demo or try how the app works for you.

0 votes
Petru Simion _Simitech Ltd__
Atlassian Partner
November 6, 2024

You can use CIFJ - Issue History Dashboard for Jira released by our company.

https://marketplace.atlassian.com/apps/1235591/cifj-issue-history-dashboard?hosting=cloud&tab=overview

 

You can export the search result to CSV, open in Excel then use Excel capabilities to find the differences.

Method 1: Conditional Formatting

1. Select the cells in one of the columns (e.g., Column B).
2. Go to Home > Conditional Formatting > New Rule.
3. Choose "Use a formula to determine which cells to format."
4. Enter: =B2<>A2 (assuming Column A is the other column).
5. Format as desired (e.g., fill color, font color).
6. Apply and repeat for the entire range.

Method 2: IF Function

1. In a new column (e.g., Column C), enter: =IF(A2=B2,"No Change","Change").
2. Drag the formula down.
3. Filter Column C for "Change" to highlight differences.

Method 3: Highlight Changes Using Excel Formula

1. In a new column, enter: =IF(A2=B2, "", "Change").
2. Go to Home > Conditional Formatting > Highlight Cells Rules > More Rules.
3. Custom Format: Format values where this formula is true.

Method 4: Power Query (Excel 2013+)

1. Select both columns.
2. Go to Data > From Table/Range.
3. Power Query Editor: Add Column > Custom Column.
4. Formula: = if [Column1] <> [Column2] then "Change" else "No Change".
5. Load query.

0 votes
Humashankar VJ
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 6, 2024

Hi @Mykhailo Goncharov 

This feature is not a native capability in JIRA, can you see the given plugin and explore will this suits your need- Issue History Tracker for Jira | Atlassian Marketplace

Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards

 

Matt Doar (Adaptavist)
Community Champion
November 6, 2024

That's one solution. There are also quite a few others listed at 

https://marketplace.atlassian.com/search?query=history&product=jira

Like • Humashankar VJ likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
atlassian, team '25 europe, atlassian event, barcelona 2025, jira, confluence, atlassian intelligence, rovo, ai-powered collaboration, developer tools, agile teams, digital transformation, teamwork solutions, atlassian conference, product announcements

🌆 Team '25 Europe registration is now open!

Join the largest European gathering of the Atlassian Community and reimagine what’s possible when great teams and transformative technology come together. Plus, grab your Super Fan ticket now and save over €1,000 on your pass before prices rise on 3 June.

Register now
AUG Leaders

Atlassian Community Events