-
Calendar App with Date Range Issues
Hey everyone. The Smartsheet Community has been so helpful through the process of building a solution to manage our workforce and the hours on our jobs. We are looking to expand our functionality to include a calendar view, but fear all the work we've done will need to be undone in order to create a usable calendar view…
-
Starting from scratch.
Hello community! I am new to Smartsheet and I am trying to work on a my Hospitals volunteer databases to bringing the 3~4 different programs that we have running into Smartsheet. We have one for each of the following; volunteer onboarding/application tracking, annual learning, volunteer time and location tracking, and…
-
Calendar View is Defaulting to Created Date and not current month
Hello I have an Events sheet that only has one date in the sheet. When we go to open the calendar view, it opens to the month the form was created and not the current month. I can't seem to change this. Is there a setting I am missing?
-
Publish a calendar showing times through 3rd party integration
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…
-
Calendar (Dynamic View) still allowing locked row to be editable for one drop-down column
I have searched and searched and cannot find an answer to this. I have set an automation to lock a row when a certain selection is made from a drop-down column. Everything in that row is locked on the main sheet for editor users. However, once the row/event is viewed in Calendar (Dynamic View), the details card has…
-
Can i not add times in smartsheet?
HI - I am putting together meeting schedules (or at least trying to) as it would be helpful - then the calendar view would have the date AND time rather than just the title of the primary column. I looked at a Q&A from 2021 and they said to use the JOIN formula in the primary column. I don't really get this. I was hoping I…
-
Calendarweeks in Gantt Chart
Hi Everyone! Is there a way to show calendar weeks in the header of a Gantt Chart? I have set the timeline to "month" as a primary header and "week" as a secondary. But instead of showing "Jun 30" for the Sunday of week 29, I would like it to show "week 26" or "cw 26" or just "26". Is that possible? Thanks Thomas
-
Publishing to Google Calendar
Hello, I have created a calendar from my sheet which I published to my google calendar. The events appear as expected however, the issue I am having is that the calendar does not show any new events added since publishing. Is there a way to have a published calendar (not the calendar app) that updates when new events have…
-
Calendar View
Hi I want to be able to show international holidays in a calendar view on a dashboard. I have created a sheet with the with Country, Start and End Dates of the holidays and the type of holiday it is. Conditional formatting has been applied to differentiate between the holiday types. I have embedded a sheet as a web part…
-
Issue with dates input in smartsheet dashboard
Hello i'm having an issue with dates input into smartsheet. the format should be in dd/mm/yy but it seems the backend is reading it in mm/dd/yy. so when i select a date like below it completely changes and also it prevents me from selecting days that are greater than 12. see pictures below for example. i select in the…