Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,369,750
Community Members
 
Community Events
168
Community Groups

Try the new Jira Cloud add-on for Google Sheets

77 comments

Hi! I just noticed that when exporting some dates to google sheets it exports the value with -1h. So 2020-12-31 00:00 in JIRA will export to 2020-12-30 23:00 in sheets. Does anyone know if there is a fix to this issue that doesn't involve rounding the values up in google sheets? I guess it has to do with daylight savings time.

Anyone on this forum able to provide some additional content with the function as listed below? I have a sample sheet called 'INPUT' with my query in A1 but cannot get the data to constantly refresh when I manually run the function and cannot determine why

function refresh() {
var cell_coords = 'A1',
sheet_name = 'INPUT',
sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheet_name),
val = sheet.getRange(cell_coords).getFormula(),
pos1 = val.lastIndexOf(' ")'),
pos2 = val.lastIndexOf('")');
if( pos1 > -1 ) {
val = val.substring(0, pos1)+''+val.substring(pos1+1);
}
else if( pos2 > -1 ) {
val = val.substring(0, pos2)+' '+val.substring(pos2);
}
sheet.getRange(cell_coords).setFormula(val);
}

Comment

Log in or Sign up to comment