Questions tagged [ms-project]
Use this generic tag for questions that apply to most versions of Microsoft Project. For version-specific questions, please use an alternate tag instead of the catch-all tag. Version tags currently include: ms-project-2003, ms-project-2007, ms-project-2010, ms-project-2013, and ms-project-2016.
652
questions
1
vote
0
answers
20
views
How to display individual resources with rolled up summary tasks?
I’m trying to see if there’s a view that can display each individual’s assigned task, with rolled-up summary tasks. Right now I have my project set up with summary tasks (milestones) and sub-tasks ...
2
votes
1
answer
434
views
Conditional formatting in MS Project Online Desktop (2019?)
I've created a new column that has "Status Notes" with the following dropdown. I'd like the background to be shaded based on the following (in brackets). Can I do this in MSProject?
I came across a ...
- 21
0
votes
1
answer
248
views
MS Project - Rollup not working to main task when not using predecessors
Can somebody help me with below. I am trying to get the correct numbers on the task Name Test Project. I would expect to see 24 hours on the duration. This only works when I use predecessors, which is ...
0
votes
1
answer
163
views
MS Project reports wrong Peak Units
How exactly does MS Project calculate Peak Units?
Let me explain the situation: I have a task named 'Task 2', it has a duration of 2 days, 20 hrs work, Fixed Duration, from Monday to Friday a ...
- 15
1
vote
0
answers
25
views
MsProject - Updating board status based on %achieved
I would like to automatically update the 'board status' column based on the % achieved.
Is this possible?
- 111
1
vote
1
answer
124
views
EVM and Schedule Variance
I am using MS Project to get Schedule Variance of a project. At this point in time I have put all the tasks associated with the project, assigned resources to the tasks (all of the resources are type '...
- 15
0
votes
2
answers
426
views
MS project shows a PV of 0 for task with resources of type cost
I am using MS Project to calculate the Earn Value of one task. let's call it Mech Installation. The task has a duration of 30 days (from 2/6/20 to 3/18/20). In the Resource Sheet I added 'Mechanical', ...
- 15
0
votes
1
answer
476
views
In MS Project :the resource calendar did not show up in the gantt chart but it shows at the resource usage sheet
the resource calendar did not show up in the gantt chart but it shows at the resource usage sheet:
i mean that, i assigned the Friday and Saturday as days off in some resources (i am using the ...
0
votes
1
answer
254
views
How do I schedule task with two predecessors based on latest finish date
I have a task (row 100) which have two predecessors, row 20 and row 30. As it is now, row 100 starts 4 weeks after row 20 has finished and 4 weeks after row 30 has finished. Is it possible for MS ...
- 1
0
votes
1
answer
628
views
Parallel task with single person poject in microsoft project
I am making plan for my personal project.I have deadline for top level task(Project Planning- 31 days). I have rough idea of how I can divide these 31 days among sub-tasks. For example, Problem ...
- 103
1
vote
1
answer
577
views
Milestone behavior in MS Project
I am working in MS Project with a project someone else set up. This project contains 29 activities which are auto scheduled, has a minimum start date constraint on an activity, and two milestones. The ...
- 113
0
votes
2
answers
316
views
Why does total cost increase each week when adding work in MS Project?
I am using the MS project, I have noticed that the total cost column of the project increases every time I enter actual work. I am not sure why that is! Could it be because some of the resources are ...
- 31
0
votes
1
answer
247
views
uneven work distribution
I was having some issues with a larger project, so I went back to something simple (KISS) to test my observations. And here's the issue: Project wants to spread the work out over the duration of the ...
0
votes
1
answer
148
views
S-Curve with % complete column on MS-Project
Does anyone have any idea or could provide me with any insight about how to setup S-Curve graph based on "% complete" column ? This would be very helpful as I am stuck with this task for 2 days.
...
- 101
1
vote
2
answers
126
views
Macro Planning Road Map
I would like to have your opinion on an issue I am facing in project management.
I would like to create a Roadmap 2020 for my team, a kind of macro planning.
A concrete example, I have a list of ...
- 85
0
votes
0
answers
104
views
Trying to create a Master Plan. Dates and duration of some projects change when inserted as a Sub-project
Trying to make a Master Plan on MS Project.
Some sub-projects were inserted with no issues, but for other sub-projects both the work effort and Duration change.
Is there a reason for this? If you ...
-1
votes
1
answer
81
views
MS Project - Application Crashes When Opening VBE & Master File
Project ver 1902 (Build 11328.20438 Click to Run), Windows 10
I have a particular master file (42 sub projects) that crashes the Project application any time I attempt to open the VBE or run a macro. ...
0
votes
2
answers
155
views
How can I create a custom assignment field, like Finish Variance, to display in Resource Usage?
I'm trying to create a finish variance field on assignments in the Resource Usage view, but I keep getting "#ERROR". Both the Finish and Baseline Finish fields are available on Resources and ...
- 18
2
votes
1
answer
108
views
MS project how to create alternative schedule to understand the impact of certain changes
We are using MS project professional.
Question : Assume I have a schedule A. There are 4 developers assigned to A as well. My management asks if they pull 2 resources out what will happen to the ...
- 141
0
votes
2
answers
256
views
How to allocate a manager to many tasks that overlap
I have a project with a lot of work going on in different domains. Say one domain is Business Process. Each domain has a single manager, for example the Business Process manager. There are lots of ...
-1
votes
1
answer
562
views
MS Project: create tasks with dynamic durations based on main milestones
From my point of view, I want to implement a straight-forward dependency in MS Project. As milestones there are:
x = project start
y = project end
The tasks are:
a = define risk management ...
- 101
2
votes
1
answer
188
views
How to identify tasks that should have started (based on completed prerequisites)
I have a MS Project plan that orchestrates multiple hundred activities over a couple of hours (the tasks also have dependencies) and would like to drive the execution based on the plan.
During the ...
- 21
1
vote
3
answers
763
views
MS Project Configuration - 80% allocation to project, max of 50% per task per day
I'm a newbie to MS Project here, so I was wondering if someone could point me in the right direction, or tell me if I'm barking up the wrong tree.
Is there a way to constrain a resource in MS Project ...
- 11
0
votes
1
answer
62
views
Why are my planned values for tasks so high when employees not working 8 hours?
I have assigned 5 resources for a task. MS Project assumes that all resources are available to work 8 hours per day 5 days per week. This is not the case in my schedule. Some of the resources work ...
2
votes
0
answers
161
views
Auto-populate Lookup values from a custom field
I have written below code for custom field 'Product_task' to take values selected for field 'SFDC Product'
as options. However this doesn't seem to work always. Please let me know your suggestions.
...
- 33
0
votes
1
answer
290
views
How to call MS Project API
I need to write a macro to reschedule multiple projects. I am able to do everything, except I am not able to perform actions exactly same as in-built Reschedule option does. Is there someway that I ...
- 33
1
vote
1
answer
223
views
MS Project Agile Showing Wrong Start/Finish Dates
Hopefully you can help provide me with insight.
So I'm new to the Agile functions of MS Project, and I have a board with sprints and tasks set up. When inspecting the dates for Start/Finish times of ...
- 11
0
votes
1
answer
348
views
MS Project schedules only 7 hours for starting day of task
I have an existing project file (.mpp file). I realized that duration of all tasks is one day longer comparing to my estimation. For example, a task with duration 2 days starting at 3.6.2019 is ...
- 3
0
votes
2
answers
54
views
Scheduling based on end date and amount of hours willing to spend per course
Given an end date and the amount of hours I'm willing to spend per course (say 250 hours each for 2 concurrent courses), how do I make MS Project Professional 2019 spread out the courses evenly every ...
- 103
1
vote
1
answer
65
views
Custom Column Calculation
We use MS Project for work. I want to create a column that multiplies the cost of 'work' resources by 5% and 'cost' resources by 15% for each task line.
In Excel I know I could use an 'ifs' ...
- 11
0
votes
1
answer
194
views
Correctly Calculate Cost Based on Units Percentage
I have an 8-month project am I planning. It's a software development project with 11 developers (and many other resources). I count "Devs" as one resource item, rather than Dev1, Dev2, Dev3 etc. On ...
- 103
0
votes
1
answer
232
views
Macro to run on projects
I have some tasks to be be performed on each project daily. I can write a macro to automate those tasks for a project. That way I have to run that macro exclusively for each project. How do I write a ...
- 33
1
vote
1
answer
675
views
How to share MS Project macro?
I have created a macro in my MS- Project. I am admin. Now how can I make it available to be used by other MS- Project users of my enterprise? Macro is created in Global file/template.
- 33
2
votes
2
answers
105
views
How can I see 'next available' tasks in MS Project?
I'm used to creating project checklists in software such as OmniFocus, which shows me 'next available' tasks: those that are available now, aren't deferred, whose predecessors have been completed, etc....
- 121
0
votes
1
answer
36
views
I have a resource who will work all day Tuesday, Wednesday & Thursday and a Friday morning every week, Can I set him up as one calendar entry?
It seems as though I can't set full days and part days in one go?
I've created a new Calendar from the standard calendar and can assign the full days but cannot see how I would split that one day in ...
- 103
0
votes
1
answer
31
views
Why are my calculated spans slightly less than my durations? [MS Project]
I calculated the span based on my start and finish dates to double check the file.
Why are these two columns not equal? Is there a setting wrong somewhere? Does this mean my end date isn't being ...
- 25
1
vote
1
answer
707
views
Why does my duration = calendar days for a 5 day work week?
shouldn't the calendar days be 2/7th longer than the duration if we're not working Saturdays and Sundays?
- 25
0
votes
1
answer
206
views
Display in the Details View --> Task Form: Sorting Predecessors by Task ID, not alphabetically
I'm using MS Project 2013 Professional
In the Details View using Task Form, displaying Predecessor view, it is sorting alphabetically by Task Name when I would rather see it sorted by Task ID. I do ...
- 1
0
votes
1
answer
164
views
MS Project: Sub-tasks causing unexpected 'Late Start'
I'm attempting to build a schedule and use MS Project to calculate dates and flow, based on constraints and task linking, but am unable to overcome an apparent issue with how the 'Late Start' is ...
- 103
0
votes
1
answer
142
views
Fix task time of day (Trip planning with MS Project)
I'd like to be able to fix the time of day that a given task must start at and its duration without specifying the actual start date. In this scenario, the date would depend on the end time & date ...
- 1
0
votes
1
answer
143
views
How to Create a Custom "Look Ahead" Field Formula?
I am very new to MS Project and I am struggling to create a Look-Ahead formula for a flag field in a master project file (collection of sub projects). I can't seem to get even the simplest formula to ...
2
votes
2
answers
381
views
How to calculate project finish date with fixed work and different date of resource availability
I am preparing a high-level project plan in mpp to see the top level view when the project will finish based on the resources availability and work estimation.
My requirement is as: I have an ...
- 23
1
vote
1
answer
2k
views
How do I Create Custom Drop down that allows multiple selections (like resource selection works)
I have a project that has multiple workstreams. In much the same way a single task may require multiple people to work on it, it also may touch multiple workstreams.
I created a custom column ...
- 11
4
votes
1
answer
3k
views
Microsoft Project - how to calculate start dates based on a set time from the finish date?
I have multiple tasks that have different durations that I want to start at different times from a go live date, i.e. finish date for an entire project.
For example: Project must finish on 01 Dec ...
- 41
1
vote
1
answer
600
views
Why does MS Project allow for a 2 day duration task with 8 hours of work and a resource at 100% units?
I have a fixed-duration task in MS Project that is 2 days in duration and 8 hours of work. When I assign a resource to the task, the resource units are automatically set to 50%. If I change the ...
- 13
1
vote
1
answer
554
views
Microsoft Project 2019 - problem allocating resources to tasks outside their calendar working hours
We have a standard calendar work week. (Monday to Friday with weekends off)
Our resources have "standard" calendar - so scheduling as standard for them is a normal work week.
However, we have ...
- 111
3
votes
1
answer
127
views
Prevent hourly tasks spanning days
Is there a simple way to block tasks from spanning days? I have some tasks such as interviews & exams which are 2 or 4 hours long but they obviously cannot span days.
However MS project is ...
2
votes
1
answer
846
views
MS Project resource graph across multiple projects
I am using MS Project to create Gantt charts for multiple projects. Each project consists of different resources but these resources are shared across all of these projects.
Currently these resources ...
- 21
1
vote
1
answer
719
views
How to plan for variable workload for a given task and resource?
I have to plan a project in which for a given task and given resource, workload changes from one month to another. How I can plan this in MS project? It is very critical for me to monitor resource ...
- 11
0
votes
2
answers
829
views
Multiple predecessors
I have predecessor 46 and 147 on task 200.
Task 147 finish date is after task 46, but task 200 is starting the day after task 46, not after task 147 as expected. How do I fix this?
I would ...
