-
Multiple Projects - all with interlocking critical paths
Hello community I don't know if anyone else has this issue. I have multiple projects, resources etc, that all overlap. I have a VP that wants to see the critical path over ALL of the projects. Is there a way to do this? I know we have critical path capabilities within one sheet, but i dont see it in a report when i put…
-
% Complete column is missing
I have created a project that seems to be working OK. I just noticed the % complete column is missing. It's quite possible that I deleted it without recognizing its significance - don't really know. How do I re-insert it. I have looked at the column insertion options and don't see it there.
-
Gantt Chart - Show Repeat activity every fortnight / month etc
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?
-
Gantt Chart sum of days for subtasks
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…
-
Formula trouble with IF or IFS
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 %…
-
Milestone task child in a % complete parent roll up
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.…
-
Setting up Project Management
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…
-
Enhancement Request - Conditional Formatting on Gantt Bars
Change the color of a Gantt bar dependent on a checkbox or other common status indicators.
-
Non-working days are no longer greyed out - Bug?
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…
-
Gantt chart top level visual summary of dependicies?
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…