can i sync a worksheet column to sync both date AND time with a google calendar? Thanks!
Hi @Jason_Williams,
Yes, you can sync the events from the Calendar view to the Google Calendar application by generating an iCal link from the Calendar view.
To sync both date and time, you need to configure the Calendar view’s Start and End dates to a DateTime column.
For generating an iCal link to use it in Google Calendar you can refer to this post: Generating an iCal link from the Calendar view and using it in the Google Calendar application
Note: After adding the iCal link to Google Calendar, any subsequent changes made to the Calendar View might take up to 12 hours to show in your Google Calendar. You can refer to the “Use a link to add a public calendar” section in the Google Calendar documentation to know more about this.
Help documentation:
- Using Calendar Views: Calendar Views - Spreadsheet.com Support
- Generate the iCal link for the calendar view: Look for the “How to Share Your Calendar” section at Calendar Views - Spreadsheet.com Support
- Use the iCal link in the Google Calendar application: Look for the “Use a link to add a public calendar” section at Subscribe to someone’s Google Calendar - Google Calendar Help
3 Likes