Taking the comments section on a kanban board and seeing it on a excel export

[Brant Killingsworth]

Hi everyone! We use the comment section on a card to reflect updated project status. I need to export to excel the list of projects (scorecards) with the last updated comment. 

Any idea on how to do this?

[Darryl Lee]

Hi @Brant Killingsworth --

If you are open to creating an "extra" field for "Last Comment", you could create an Automation that updates that field whenever a comment is added to an issue, and that field could then be included in an Excel export.

For reference:

• Jira Automation Triggers - Issue commented 
• Jira Automation Actions - Edit issue 
• JRACLOUD-2734 - Display last comment in issue navigator column (comment detailing how to create automation to update custom "Last Comment" field) 

Outside of Automation, if you have ScriptRunner, you can also create a Scripted Field that does the same thing: 

• Show Last Comment for an Issue (Server/Data Center) 
• Jira Cloud Script Field to Get Last Comment text and display it on an issue 

And there is also this add-on for Jira Cloud that provides a "last comment" custom field, amongst others: Comment Custom Fields for Jira 

[Darryl Lee]

Oh and yeah, I don't believe you can export a Kanban board to Excel. You'll need to go to Issue Filter view, and you'll want it to be the same filter you're using for your board.