-
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…
-
30-Day Prompt
Hello, I'm needing to create a sheet where a task has a start date of say, 11/1/2017, and then I need to be reminded of something 30 days from the start date, 11/31/2017. Can someone help with the formula for that? (Column A would be "Task" and Column B would be "Start Date". I'd like Column C to be "Action Date." There's…