-
Fixing the Gantt timeline to Years and Months
Hi all, Something is driving me a little crazy and I wonder if anyone could help? Our client likes programme timelines to be displayed like this: - primary heading: years - secondary heading: months This works fine until someone zooms in or out (using the +/-) buttons on the Gantt chart. When they zoom they are unable to…
-
Not possible to color Gantt bars by what parent task they are under?
I'm setting up a project with big task parents for the major parts of the project with many sub-tasks. Is it not possible to use a conditional formatting rule to make all the tasks under a particular parent a specific color?? This seems like a very basic feature but I can't figure out a way to do it.
-
Create Task Start and Finish Dates with Mouse in Gantt?
Is there a way to create start and finish dates in the Gantt chart view by simply clicking/dragging on the Gantt chart calendar? It seems the only way to initially create a start/finish date is by using the Start column and clicking on a date on the calendar that appears. This is clunky and it would be much easier to just…
-
Amount of Working Time Between Tasks
We have a desire to calculate the amount of work time between the end date of a task, and the start date of it's successor task. Before the update that included partial day durations, we were performing this with simple date arithmetic. Now, that arithmetic does not hold true, and we need to devise an updated formula to…
-
Parent Rows as Milestones???
Is it possible to make a parent row a milestone as well?
-
Subtask Dependencies Error Message "REF"
I am getting a "REF" message in the subtask cell for Predecessor column. For example: Line 3 Start SF, start date: 8/18/15; end date: 8/18/15 = I entered the number 2 Line 4 Update SF, start date: 8/19/15; end date:9/17/15 = I entered the number 3 Line 5 Review SF, start date: 8/19/15; end date: 9/16/15 = I entered the…
-
Is it possible to Auto-Fill dates?
Hello, I'm sorry if this question has been asked before, but I couldn't find anything through the search function... I have prepared a template for event management. We use the same structure for every one of these specific events that we do (the event date is announced, and then we work back from the date to establish…
-
Resource Availability
I need to figure out a way to view resource availability for a given time period, besides just visually scanning the resource view. Is there a way I can create a report that would tell me the dates that a given resource is not scheduled/assigned to a task across multiple sheets, so I can assess that resource (or group of…
-
Dependencies by Assigned User
Can dependencies by automatically set by Assigned User? i.e. Fred has 5 tasks each will will take a day - can the start and end date be automatically set with dependancies?
-
Assigning Colors to Contacts
I use the gantt charts and calendars to make sure my contractors are not in two places at once. Is there a way to color code each contractor so when I assign a task, it automatically shows in gantt and calendar view as the color assigned to them? I seem to have to do it to each individual task. Then the color coding doesnt…
