Try the new Jira Cloud add-on for Google Sheets

[Jannik Ackermand]

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.

[Scott Tiller]

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);
}