Hi All I am wanting to show an activity that needs to happen every week or month on a Gantt chart in one row. Any suggestions please?
Hello everyone, We're using gantt charts to planify our tasks. When creating task groups and sub-tasks, the number of days displayed in the task group does not reflect the actual number of days planned but the time span from the beginning of the first task to the end of the last task. This creates confusion when presenting…
I have a sheet being used as a project schedule in which I want to auto-indicate the project lifecycle stage in a cell on the sheet's meta-data line. To do so, I envisioned using an IF AND statement or something similar. Below is a mock up of the way it might look in excel. Project Lifecycle Phase = XXXXXX COLUMN B C Row %…
I have a number of milestones (0 duration lines) in my projects. These represent decisions, meetings, inspections and deliveries. I also use % complete to communicate with our finance department, customers and project team members. These factors don't seem to play well with each other in the schedules I have set up so far.…
Hi - I am creating a project management template for events. One of my tasks is sending out emails to customers. We don't send emails on Mondays or Fridays, so if I build out my dependancies, is there a way to exclude Mondays and Fridays only for those rows? I know I can set up parameters for the project but can I set…
Change the color of a Gantt bar dependent on a checkbox or other common status indicators.
Hello My smartsheets are no longer greying out the non working days for me, even though I have specified sat/sun are weekend (first image). I have tried clearing formatting but it doesn't fix it. My colleague sees the non-working days when he opens the same sheet. I also can see them in the background when I click 'edit…
Hi, Is there a way when you collapse a top level item in a gantt chart to see colored shadings of the dependencies within IN that top level overall grey bar? Let them take the color from the assigned color of the dependency? For instance, I have 4-6 items within an entry but I don't want to expand the entry just to see…
Hi there, I'm trying to use the function "WORKDAY" in order to have an end date output, based on a calculation, but when the "number_of_days" value is not a whole number, the formula returns an error. How do I have the formula always round up? Is it possible to mix the formula with the function "ROUND" with 0 digits? Thank…
I seem to have deleted the duration column from my spreadsheet and can't work out how to get it back! Can anyone help... thanks