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?
