Sign in to join the conversation:
I have been using the Smartsheet calender for awhile but we use Outlook calendar at work and I was wondering if there was a way to sync my Smartsheet calendar with my Outlook calender. Is this possible?
Hello John - While in the calendar view, click on the Publish Calendar to iCal (on the toolbar to the left). At the bottom of the Publish Options menu, click the button for iCal (Calendar) to enable. From here, you can select “Add to my calendar” which will add the calendar to your computers default calendar application (such as Outlook) or you can copy the .ics link into Outlook or any other calendar application that supports .ics links.
Here’s more information on publishing calendars: http://help.smartsheet.com/customer/portal/articles/775707-publishing-a-smartsheet-calendar-to-ical
Thanks Travis - this is exactly what I was looking for!
Thank you! I have been looking for this too!
I did this a while back but I have found Google Calendar works better for our needs. Outlook does not allow you to update the calendar. You have to go back to Smartsheets to change any dates. Not only can you update the calendar in Google but when you do it also updates Smartsheet at the same time. Plus the update time in Google is almost instantaneous where as Outlook takes about 15 minutes to update.
Just discovered this function. Great to know about the delay in sync updates!
I've done this through the instructions for the Publish tab, but the iCal does not appear to be updating (it shows the original dates of events who's dates changed months ago). I've sent a note to support to see if it can be fixed.
Hi Ryan, I looked into your open ticket with the Support team. From the email thread, it appears the sync is working on a new sheet you created - but not the original sheet in question. I would continue to work with the Support team and let us know when you have an answer!
I, too, really value this feature and depend on being able to see my Smartsheet calendar in Outlook. But I'd love to be able to EXCLUDE the sync of the full project and just be able to sync the sub items. Is there a way to trick the system into doing this? Below is a rough sample of the top line (parent) which I'd like to exclude from sync followed by the indented sub tasks that I do want to sync:
2015-12x report | 50 pgs (40+10) 12/07/15 03/10/16
Outline Docs 12/07/15 12/08/15
Outline MTG 12/09/15 12/09/15
Rough draft Docs 01/04/16 01/06/16
OrgEdit/PD MTG 01/07/16 01/07/16
PUBLICATION 03/10/16 03/10/16
Hi Rachel, while you can choose to see only child rows while in your Smartsheet calendar, when using the iCal subscription link with Outlook, all tasks will be displayed, including parent rows.
Does this work for reports? If not, please add it to the roadmap?
Hi Gordon-- We don't currently offer syncing with Outlook or Google Calendars in Reports, but I've added your vote for this to our enhancement request list. Thanks for your input!
I second this. It would be perfect if I could publish to Outlook from a report.
I agree - being able to generate ical links from reports would be a huge benefit. This would be a work-around for filtering what the end user receives in their calendar - you could create a report specific to a group and that would be their calendar feed, instead of seeing the full smartsheet in their calendar.
Voting to add ability to link reports to calendar. Our master sheets are too much information for calendar users "overload".
I Second This request. Reports would greatly benefit from this feature!
Hi there, I need help setting up an hourly automation for our Department Calendar sheet. Here’s the situation: This sheet is connected to the Master Events sheet via Datamesh. When an entry is cancelled, Datamesh needs to trigger on the master sheet before the entry is archived from this sheet. If the entry is archived…
Hello, I have a provisioned project that was customized by a fair number of Dynamic Views that are used on the project Dashboard. I believe that Smartsheet still does not provision Dynamic Views otherwise I would have revised template set and simply provisioned new project. Now I would like to add a new project with…
Hi. I'm trying to create an automated workflow that when the trigger is met, a generated document (via the Mapping I've already created) would be attached to the appropriate row. I've tried multiple times and it doesn't seem to be working. So I researched in the Help Center and found in this article…