-
Daily Reporting to Document Generation
Good Afternoon, Our construction firm utilizes a standard Gantt chart sheet to track our project's daily reports. Under each category of work we have milestones, i.e. Carpentry :: Framing :: Drywall etc. Under each milestone we add a child for that days work, i.e. Drywall :: Day 1 - Mobilized :: Day 2 - Started Hanging…
-
Conditional formatting doesn't work on Gantt chart
Hi, I set up the below conditional formatting. As you see it works for the row formatting but not for the task bars. It doesn't have any children rows. Any idea what might be going on? Thank you!
-
Allocate tasks to non-existing team members
It's very important at the beginning of a project to put together a plan speculatively, to identify additional team members we might want to hire/contract work to. I don't seem to be able to do this - typically I write a placeholder for the new hire (e.g. 'PCB engineer 1'), and it would be great to see the resource…
-
Trouble with Chrome Base web interface, no horizontal scroll
Hello - Is anyone else experiencing this? We have several google "chrome base" desktops, (just like a chrome book laptop, only a desktop).....while working from with in the chrome web browser, on the chrome base, we are not able to use the horizontal scroll in the grid view. We have to resort to selecting a cell, and using…
-
GANTT - Set Manual Start Date + Define Predecessors (for the same task)
// Current situation Currently, adding (1) manually a start date for a specific task AND (2) defining certain predecessors for the same task is not possible // Problem Description Let's imagine, we have the following two tasks to plan: Task 1: Starting at day 1 and a duration of 10 day Task 2: Starting at day 15 and a…
-
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…
