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

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_
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

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
AUG Leaders

Atlassian Community Events