Dave Parsons

That's an interesting idea, but there isn't a way to do that now. If more people express an interest in this, I could take a look at it.

I can't seem to re-create this problem on my computer. I'm in the US/Pacific time zone (-7) and have no issues. I've set everything I can think of to New...

Or this is interesting, the dates seem to actually start going off by one day when I set the "secondary time zone" in Calendar settings. When I unchecked "secondary time...

I might have figured out the problem. I just uploaded a new version that uses the spreadsheet's time zone for all-day events. Hopefully that works for you.

Interesting. You should be able to sync to the calendar multiples times without generating duplicate events. Do you have an "Id" column in the spreadsheet? When you sync, the IDs...

Correct. The script uses the event ID to sync changes between a calendar and spreadsheet. The ID is what the Google Apps Script Calendar API uses to identify events. I...

So one of the calendar fields (title, description, start time, etc.) is a formula? Or is the formula in a separate column that's not used in the calendar event?

I see. So for example you might enter a start time, but have a formula for end time. Unfortunately, I think it's going to be pretty difficult to try to...

Now I understand. Sorry it took a while for me to catch on. After the script updated the calendar, it was overwriting all the formulas. That should be fixed now....

When I said update the calendar ID, I just meant if you copied the script again. It has "YOUR CALENDAR ID HERE" in the code. Not sure why the headings...