Jira Cloud for Sheets - Extra column sync

styliani.avgoustidi

Hello Team,

 

I have an Excel file where I frequently extract data from several Jira tickets. I need to add an extra column in Excel for making notes for each ticket. The problem is that after refreshing the data, the extra column doesn't update, and the rows do not align with the Jira data. Is there a way to resolve this issue without adding extra fields to the tickets? 

Magdalena Zhisheva

Hi @styliani.avgoustidi , 

What I can advise you is to use Google appscript to automatically copy the data from the first sheet (where the connection with Jira is) on a certain period of time to a new sheet. You can specify in the script that you need to keep column "X".

 

Hope it makes sense