-
Can Smartsheet show a Gantt style bar that shows monthly RAG status trend?
I am new to Smartsheet and have a POC developed in Excel that allows us to have a gantt style timeline that is coloured by month according to the monthly RAG status. This RAG status is conditionally formatted based on whether we indicate 1, 2 or 0 in the cell but is not shown. We can also add activity descriptions in the…
-
Highlight critical path
I have just started trying to use Smartsheet for project planning. I have created a Gantt chart for my project, and entered dependencies, durations and resources. However, I haven't yet found a way of highlighing the critical path. When managing a project, it is useful to have the tasks and the dependencies that are…
-
gant bar color
Hello, I am desperately looking how I can change the color of a gantt bar. Right clicking on it .. only shows me "edit" option .. but not "color" option. conditional formating : If I select to apply a color to the whole line .. then it allows me to indicate also the gantt bar color .. . If I select eg red .. it doesn't…
-
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…
