-
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…
-
Setting intermittent dates for a single task
I am just getting started with Smartsheets. So far, I am really liking the ease of set up and functionality. One issue I am struggling with is how to set up intermittent dates for a single task. For example, I have a single task where I want to set a date for every other Friday to meet with the client. I don't want to have…
-
Gantt Chart
Hi everyone, The Smart sheet is very good for short term projects. For a long term project that spans across more than ten years, is there a way to download a entire Gantt chart? Thanks, Liping
-
Gantt Chart Task Percentage Color
How do you change the color of the percentage indicator inside the bar of an individual task? In conditional formatting, you can only change the color of the task bar itself and not the color of the percentage of the task. Thank you.
-
is there a way to make children auto-calculate percent complete based on start/end date and the curr
I'm new to this program but not scheduling in general. Is there a way to get each child beneath a parent to calculate % complete automatically, based on the entered start/finish dates and the current date? I'm building construction schedules, and don't want to have to manually update huge amounts of child rows, especially…
-
Gantt Chart Due Date Flag / Milestone
Hi, Is it possible to show a 'flag / milestone' as well as the duration bar on one line of data. I would like to have a due date associated with a task, as well as a duration. Such that I can see instantly how close I am to a due date. Thanks
-
Weeks Out Calculation based on Nested IF Statement
I'm having trouble having my weeks out calculation work based on the results of a Nested IF Statement. The If Statement works if I use quotation marks around the results which need to display a date. The problem is that putting the quotes around the results converts the number (in my case a date) into text and no longer…
-
multiple date columns
i have created a sheet that has a notification date column and then a start date column and then an end date column. i only want the ghant chart to pick up the start and end date columns and not the notification date column. how do i do this???
-
% allocation
I have read a few posts regarding the inability of the tool to automatically update duration based on changing % allocation of a resource i.e. Task A will be completed with 1 day duration by Resource X. I change Resource X to 50% allocation and the duration should automatically be updated to 2 days. The last post I read…
