iCal to Smartsheet

Jeremy Jason · 06/08/23

Hi Community,

I am looking for a solution to export an iCal into a Smartsheet. Our company uses a software to track vacation time and project assignments and can export into a web calendar. Is there a way to link this information back into a smartsheet to show everyone's OOO dates in a Gantt chart?

I've only found an outside integrator such as Zapier as the solution. Is there any internal way to smartsheet to do this?

Kleerfyre · 06/08/23

Not sure you can go iCal to Smartsheet, but I know you can go Smartsheet to iCal. Maybe this article could help:

iCal Calendar Sync

https://www.smartsheet.com/marketplace/apps/ical-calendar-sync

Publish your Smartsheet task dates and deadlines to your external calendar programs.

Do you have access to any of the premium apps? There might be a solution within those apps if you do, but I haven't seen an iCal to Smartsheet solution out of all of my experiences so far.

Jeremy Jason · 06/08/23

Kleerfyre

Jun 8, 2023

Not sure you can go iCal to Smartsheet, but I know you can go Smartsheet to iCal. Maybe this article could help:
https://www.smartsheet.com/marketplace/apps/ical-calendar-sync
Do you have access to any of the premium apps? There might be a solution within those apps if you do, but I haven't seen an iCal to Smartsheet solution out of all of my experiences so far.

Thank you Kleerfyre! Unfortunately, that only goes the wrong direction. Employees have already entered in all their travel, we just need to input it to Smartsheet. Our current workaround is manual data entry, so any time save would rock.

Kleerfyre · 06/08/23

So with that, do you have access to any of the Smartsheet Premium apps? If so and part of that access includes Bridge, then you might have an option there, but I haven't used Bridge enough to say for sure.

Jeremy Jason · 06/08/23

Kleerfyre

Jun 8, 2023

So with that, do you have access to any of the Smartsheet Premium apps? If so and part of that access includes Bridge, then you might have an option there, but I haven't used Bridge enough to say for sure.

I do! I can keep poking around in Bridge and see if I can find a solution in there.

Kleerfyre · 06/08/23

That is going to be your best option. Another solution that is outside of Smartsheet is one I just recently found in another post here is make.com. You could also look there to see if you could make a solution.