-
The option to change parent row calendar colors when dependencies are enabled
I have several tasks in each of my sheets that I want to see in a report for major milestones. I want the different tasks to have different colors. Right now it is possible to change the color of children rows on the Gantt Chart/Calendar view, however when dependencies are enable, it's not possible to change the color of…
-
Time Management in Start and End Date
Hi I saw some items where people wanted to manage time in Start and End Date. This is a feature that interets me for laptop usage. Can you tell me please if it is planned en the smatsheet roadmap ? Thank you for answer
-
What is the best way to consolidate data from multiple sheets?
I have multiple projects running side by side and I need a method to view a high level overview of all my projects with real data and a Gantt chart. I know I can use reports but reports do not support Gantt charts or a calendar. Does anyone have a better solution for how to do this?
-
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:…
