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.
628
questions
2
votes
0answers
77 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.
...
0
votes
1answer
264 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 ...
1
vote
1answer
158 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 ...
0
votes
1answer
186 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 ...
0
votes
2answers
51 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 ...
1
vote
1answer
51 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' ...
0
votes
1answer
142 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 ...
0
votes
1answer
174 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 ...
1
vote
1answer
437 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.
2
votes
1answer
50 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....
0
votes
1answer
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 ...
0
votes
1answer
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 ...
1
vote
1answer
499 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?
0
votes
1answer
115 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 ...
0
votes
1answer
103 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 ...
0
votes
1answer
108 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 ...
0
votes
1answer
91 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
2answers
300 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 ...
1
vote
1answer
1k 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 ...
4
votes
1answer
2k 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 ...
1
vote
1answer
396 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 ...
1
vote
1answer
414 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 ...
3
votes
1answer
106 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
1answer
580 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 ...
1
vote
1answer
495 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 ...
0
votes
2answers
697 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 ...
2
votes
1answer
277 views
Rotating-schedule calendar
I'm new both to MS Project and this kind of forum. I've searched for this question and I haven't found it, so sorry if it has been already asked.
I'm trying to make new resources calendars, but they ...
3
votes
1answer
103 views
How to divide a generic resource?
I am still new at using ms project Professional. My project has already assigned resources.
For instance, let's take developers who together have a maximum effort of 200%, which means I have 2 ...
1
vote
4answers
268 views
Should activities before kick-off meeting be represented in a Schedule Plan
I wonder if activities like contract and agreement reviews, meetings to discuss preliminary information, SOW review, and contract approved (as deliverable and milestone) should be included in a gantt ...
0
votes
1answer
231 views
ms project - delay a task due to unaviability of 1 resource
I want to schedule tasks using multiple resources. The work task is fixed and multiple resources are allocated to the tasks.
I want to auto-schedule the tasks, however, when 1 resource is ...
-1
votes
1answer
95 views
How to effectively implement Scrum for a small project (max duration 6 months) with defined project deadlines?
In my current company, they are using Waterfall methodology in defining the gateways for new project approval and developing detailed timeline with completion date (gantt chart) based on the ...
1
vote
1answer
40 views
Add Landmarks lag or date based on project start date
My project have some tasks (landmarks) that occurs at every X month, like:
- Project technical report (PTR) at each 4 months
How should I define the landmarks date relative to project start?
...
3
votes
1answer
423 views
How to add new task below the currently selected task
When adding steps/tasks to a project plan, I often do this sequentially in the order they need to be done.
However, pressing "Insert" adds the new task above the current task. How can I add new ...
2
votes
1answer
369 views
Assign Resources Automatically in the Most Efficient Manner
Firstly I have to state that I am not a project manager. I am a software development team leader that has been tasked with giving a plan for a large project for my team. We work in a Scrum-like ...
1
vote
0answers
1k views
Project Online - Enterprise Custom Field Not Calculating Formula Correctly?
I am new to MS Project (~1 week experience) and could use some help with an Enterprise Custom Field I'm trying to create. I'm using Project through Project Web App in Office 365 (I assume this is ...
3
votes
1answer
184 views
Create MS Project report which to return incomplete tasks per user with due date
I want to be able to produce a report I can share with resources on a project so that they have visibility on what outstanding tasks they have (overdue, current, future) and when they are due.
...
2
votes
1answer
182 views
MS Project Change Working Time - Roster
How can I change the working time to 2 weeks ( working - 14 days) and 1 week (not working - 7 days)? Is this able to be automatically populated?
3
votes
1answer
165 views
Change task distribution with % completed
I'm using MS Project 2010. When assigning a task with duration say 5 days and work of say 10 hours. Then MSP distributes the occupation for that resource over the whole duration.
e.g.
Mon 2h | Tue ...
2
votes
1answer
38 views
How to share with a link to a viewer with stakeholders
I'm tired of trying to keep everyone partially happy - some prefer excel, some prefer pdf, very few have ms project.
What I'm looking for is a simple link that I could send out to everyone, giving ...
3
votes
1answer
719 views
MS Project - Link multiple columns to the Resource Sheet
I have (somehow) managed to create one column which successfully links to the Resource Sheet. When using the drop down, it brings up all of the names in the resource sheet, and allows you to choose ...
1
vote
0answers
29 views
Add columns in master project from external project tasks
I have created a master project ( in ms project 2010 and published in ms epm 2013)that contains only key milestones tasks from external projects. Hence this master project plan contains high level ...
2
votes
0answers
155 views
Ms project - Avoid task split up in minutes
I am trying to update my ms project plan with the following:
- replan al 0% and partly completed tasks from the new status date.
- Tasks can be split up
- Plan based on priority and available time for ...
4
votes
1answer
1k views
Resource-Task table in MS Project
Does anybody knows how to export workload of single resources (columns) per task (rows) from MS Project? The result should look as follows:
.............Resource 1.....Resource 2.....Resource 3 Task
...
1
vote
1answer
67 views
Autosave: How to prevent it being re-enabled with each new session
I find the Autosave feature to be very intrusive and it also interferes with some macros I run. I know how to disable it via File/Options/Save/untick the box, but even if I then immediately save my ...
1
vote
2answers
1k views
Work days and Duration does not match
I am using a 5 working days & 8 hours standard calendar. My task is 30 days . I have selected a start date on Monday and end date on Friday (30th work day) but the durationn reflects as 40 days ...
1
vote
1answer
92 views
Report in MS Project (Hr/task/resource)
I am trying to find/create a report in MS Project 2013 in order to display hours done in a month by a certain group of resource or a resource only (they are already grouped in the Allocation tab) with ...
3
votes
3answers
59 views
Sharing a file without them being able to edit the main file
I need to either create or share my project with others. I don't want them to be able to make changes to my project though. I've tried creating a new one, but they still are able to make changes to ...
0
votes
1answer
2k views
Tracking Gantt Chart Not Showing All Tasks
I am trying to do an earned value analysis and there are tasks in my normal Gantt chart that when I switch the view to tracking gantt are not visible. Could this have to do with where I set my status ...
1
vote
1answer
235 views
Leveling; getting unexpected results
I have spent hours reading up on the leveling algorithm and trying various alternative approaches but I have a problem I simply can't figure out. I'm using MSP 2016.
My schedule consists of around ...
1
vote
1answer
450 views
MS Project - Summary Task split by leveling
I have a summary task, and have the 'Leveling Can Split' option set to No.
The four subtasks which are in sequence, also have LCS set to No.
In the Leveling options I also have 'Leveling can create ...
