Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you