Publish a calendar showing times through 3rd party integration

Tim Starkey
Tim Starkey ✭✭✭✭✭
edited 04/01/24 in Add Ons and Integrations

Looking for a way to publish calendars to outlook and have them display at the correct times, not as all day events.

Based on community post review, I am assuming the following:

  • It is not currently possible to store a time in a date column (although the created/modified columns have that ability)
  • Published calendars show rows as "all day events"

In my sheet I have a start date, a start time (drop down), end date, and end time (drop down)

Has anyone found a way to create a published time based calendar using a 3rd party "middle man"? For example, sync the smartsheet to google sheets (or some other integration). That 3rd party then combines the date columns and the time columns into a single date and time column, and then publish that calendar?