Syncing Smartsheet Calendar with Google Calendar

Julia Wong

Hi

 

I would like to sync my smartsheet calendars with a google calendar so that I can have one centralised calendar for all of my sheets.

 

However, when I sync them, I loose the conditional formatting (which I use to colour code the different types of tasks/appointments in smartsheet).  How do I maintain the colour coding?

 

Or, better yet, how do I sync the calendars within SS to one 'master/uber' calendar without having to export to an external program?

 

Thanks

Julia

Travis

Hi Julia, the Google Calendar integration does not allow formatting to be displayed in Google Calendar. It may be possible Google will make this available in the future, but at this time, only the tasks will be displayed. 

 

As far as making a master calendar, try using reports. Reports can pull in data from multiple sheets into a unified report and show the data in a grid, Gantt and calendar view. 

 

Here's information on reports: http://help.smartsheet.com/customer/en/portal/articles/522214-creating-reports