-
Date selector on Sight - going back to past snapshot
Hi Smartsheet Community I checked a couple of posts but couldn't really find an answer, here we go: Sights are technically always showing real-time status. As I need to submit monthly updates to our leadership team and we want to track status trends, is there a way to re-visualize a past view of a dashboard? Or is the only…
-
Round the clock schedule
Hi, when planning / executing big IT application cutover or implementation, which sometimes can span for 1 week, the involved teams will work in shifts in a 24 7 schedule. To track all this work and its dependencies, a detailed schedule is created including start date, start time, finish date and finish time with time…
-
Help: Change GANTT to Year/Month in Widget
I can change my GANTT chart in the project sheet to Year/Month display. But when I create a report and display the GANTT in a widget in the Sight it will only show the GANTT by Week/Day. I need it to show by Year/Month. Can this be done with the report widget? or is there another way to show the GANTT in the Sight for the…
-
Task Duration - Partial day at beginning of period, not the end
Hi, I notice when you add a half day duration to a task, it places the half day at the end of the period, for example a start date of 13/11/17 (Monday) with a duration of 2.5 days will result in the half day being on the Wednesday. Is it possible to make the half day on the Monday and the full day on the Wednesday? I'm…
-
Google Calendar
With the Google calendar refresh coming out on the 28th does anyone know if we will have to re-publish our smartsheet calendars to Google?
-
Google Calendar
Hi everyone, I am trying to sync my smart sheet with my google calendar, but it appears that only the "Task Name" column comes over. Do you know of anyway to get a column to sync with the Address or Description fields in calendar events? Thanks!
-
Calculate the Xth Weekday of Any Month
I am new user to Smartsheet and I am trying to figure out a formula that will calculate a date for a question like "What date is the 3rd Monday of a given Month". Through some google searching I came across this answer for a straight excel formula:…
-
New sheet based on filter?
I created a filter which only shows the launch dates. I'm trying to export these dates to iCal but whenever I do the filter is not applied within iCal and it includes every subtask. I figure a work around would be to make a new sheet with only the filtered launch dates and export that to iCal, however I can't figure out…
-
Gantt chart changes to quarters instead of months when printed
How do I export to pdf and show months instead of quarters? I am only seeing my gantt chart as quarters.
-
Standard Calendar layout template?
I want to explore using Smartsheet for editorial calendars. I'm having a hard time finding any templates that display as a monthly calendar with seven day of the week columns and rows for each week. Is this something that exists in Smartsheet or should I look at another option?