-
Count down in days formula
I need help finding the right formula. I have basic Gantt with four phases, each phase has tasks associated with it as well as durations. I've set a "start date" column and by using durations for each task and predecessors I then have the calculated "finish date" column for each tasks and each phase. I need to create a…
-
'Conditional'/Multiple Predecessors
Is it possible for start date of a task to be based on dates tied to one of two other tasks? E.g. Task 2 must start not more that 10 days from completion of Task 1. Under normal circumstances, this allows task 2 to start not more than 10 days from start date of task 3. If start date of task 3 must be accelerated, however,…
-
Contingency duration based on predecessors
I was wondering if it is possible to create a task whose duration is determined by two predecessors, one from backward planning and one from forward constraints. I would like to use this, among others, to show dynamic contingency periods in my project. Let's take the simplest example, a project with the following three…
-
Split Screen for scrolling on Reports used in Dashboards
It would be helpful if you could scroll through the Gantt view of a report, separately from the Task view, when looking at a report that is embedded within a Dashboard. Today, there is only a single horizontal scrollbar and you can quickly lose sight of the associated tasks as you scroll to the right to see everything in…
-
Use formulas in percent complete column with dependencies enabled
I have a formula in my percent complete column, but when I enable dependencies (in my predecessor column and duration column) the formula gets wiped, leaving only the value behind. Is there a way to keep the formula when enabling dependencies or is this just a limitation of smartsheet?
-
Critical Path not displaying
Hello I have read various other posts about CP not showing. My last task did have a red border but I have since altered this. There is not CP showing. Any advise will be welcome. Thanks in advance Matt
-
Can't Remove Dates
I have an old project that may or may not resume. Either way, I want to kind of archive it by removing any dates and moving it out of the way to the bottom of my sheet of projects. I have a few Master Tasks with subtasks. I deleted all the dates on the subs but there are still dates on the masters. I have filters that…
-
Due Date won't edit
Hi everyone Once I type in a date in my Due Date column, it won't let me change that date. Every time I edit it, it changes back. If I delete the field, it will become blank, but as soon as I try to type another value in, it reverts back to whatever the first date I entered was. Can anyone help? Thanks! Harry
-
Is there a way of putting a Vertical line on the calendar in Gantt View
I have created a project sheet with milestone however I want to have a line on the Gantt view that goes from top to bottom on a particular date any ideas?
-
Financial Year - Weeks view in Gantt chart
Hi I am wanting to display the FY weeks in Gantt view, not Fiscal year. Is there a way of doing this?
