search

jamietr1 / google-docs-writing-tracker

Automation scripts to track writing in Google Docs
187 stars 39 forks source link

Time-zone mismatch? #38

Open sixpence668 opened 7 years ago

sixpence668 commented 7 years ago

I have the spreadsheet, scripts and triggers set-up correctly as far as I can tell, but I keep getting the following error: Error: CONFIGURATION: The timezone settings of the writing spreadsheet and scripts do not match. Please ensure both are set to the same timezone. See README for details. Script TZ: America/Mexico_City Spreadsheet TZ: America/New_York (line 68, file "code")

I've triple checked the spreadsheet and it is set to Central in the spreadsheet settings, to match the settings on the scripts. Is there an internal place I need to also set the timezone to resolve this?

scifigirl commented 7 years ago

Had the same problem. Did you go to File > Spreadsheet settings.... to check the spreadsheet timezone?

sixpence668 commented 7 years ago

I did, several times. I ended up deleting and reinstalling everything, and that issue seems to have cleared up.

jennsull503 commented 6 years ago

That's what worked for me, too. I had to delete everything and then reinstall and set the time zones when I was setting it up. Everything worked fine.