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:
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:
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.
You can use CIFJ - Issue History Dashboard for Jira released by our company.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
That's one solution. There are also quite a few others listed at
https://marketplace.atlassian.com/search?query=history&product=jira
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.