-
Min - Max Durations on Gantt Schedules
It would be very helpful to input a minimum and maximum duration for an item and have the color bar shown with two tones. This would enable us to see where optimization is possible while still planning conservatively, or vice versa. There would need to be a setting for where to connect to the next item, i.e. minimum (best…
-
Gant Chart showing budget
Hi, I have created a Gant chart and need it to show dollar figures per quarter in a new row but I cannot work out how to add the row. the highlighted line is what i would like to add across the gant chart side. Like the below example from excel Thanks Tanja
-
Allow Gantt view to use Date columns with Column Formulas for Start/End
I'm kind of flabbergasted that this is not currently possible in a Sheet, and I'm struggling to explain to my users why. It is already possible to populate a Date column with a Column Formula and then convert it to a Cell Formula, and then use that column as the Start/End for Gantt view / Project Settings, so the issue is…
-
Negative Float
Can anyone tell me what would have to change in the plan below for me to end up with a negative float? It seems that if I add any duration to Activities B through L (which I would expect would create a negative float), the end date for the final task (Activity M) simply gets pushed out to compensate. No Negative Float…
-
Multiple Date Ranges within the Same Row
From what I read this is still not an option with Smartsheet. I would also like to have multiple date ranges within the same row. I would like to be able to look at a project (start to finish) but also like to see Section A, Section B, and Section C date ranges within that project on the same gantt chart row. I currently…
-
Formula to Flag Tasks that are on the Critical and / or Driving Path
I'm aware how to highlight these in the Gantt, but if I wanted a checkbox to flag which tasks are on the CP and which ones are on the DP, anyone have an idea how to do that?
-
grantt view
i have created a report with data from 2 different sheets, each with "start"- data and "finish"-data, both columns are in the 2 sheets, the confiugration behind is for the the 2 sheets the same when i use a grantt view in the report, it displays in a correct way the data from the first sheet, but for the second sheet he…
-
How to exclude weekends while using formulas
I am very new to smartsheets and have just been playing with it and need guidance. I am trying to keep it as basic as possible. Essentially we are trying to backwards plan from our "due date" of when to begin our parts. i have it where you manually plug in a "shop time" and manually plug in a "outside lead time" have a…
-
7 AM shift start and Lunch time
Currently Smartsheet Project uses a default 8 AM time as the start date for each day in a project schedule. Is there a way to change that to 7 AM? I am stuck in creating a formula for that. Also, is there a way to take out the one hour lunch that is automatically calculated in a schedule?
-
View "Today" line in Gantt on Dashboard
In a Report, I see a vertical line for "today's date" on the Gantt Chart. However, when the report is dropped onto a Dashboard, the vertical line is not displayed. Any suggestions?
