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.
525
questions
0
votes
1answer
27 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
0answers
9 views
MS Project 2016 dashboard
would like to ask if there is a formula or custom visual or field that will show the count of activities that are completed, On schedule and Late??
0
votes
1answer
41 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 ...
0
votes
0answers
12 views
Button to run macro in MS Project available for all users
I am not able to find how I do I make a button available at enterprise level to run a macro. I have nothing showing up in Modules tab in Organizer though I have written Macro and successfully made ...
1
vote
1answer
17 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
0answers
21 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
31 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
27 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
40 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
14 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
28 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
39 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
24 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
53 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
26 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 ...
0
votes
1answer
24 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
41 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 ...
0
votes
1answer
23 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
0answers
53 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
42 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
44 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
125 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
39 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
64 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
126 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
37 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
57 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
17 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
27 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
73 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
367 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
34 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.
...
0
votes
1answer
79 views
Microsoft Project IIF (immediate if) limitations
I'd like to understand better the restrictions applied to IIF (immediate Ifs) on MS Project 2016, such as:
how many nested iifs are allowed
how many characters are accepted in a formula
how many ...
2
votes
1answer
35 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?
2
votes
0answers
36 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
36 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
59 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
23 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
45 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
65 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
43 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
1answer
206 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
31 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
48 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
419 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
67 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
67 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 ...
3
votes
0answers
37 views
Determine to which task a resource is allocated on a particular day
Using a shared resource pool for several project plans (each plan is contained in a separate file), what is the simplest way of working out to which task a given resource is allocated on a particular ...
0
votes
1answer
350 views
Working and non working days
I want to ask if I need to have non working days and working days in a same day. Can we do that in microsoft project?
For example Saturday (same date) for items Consultant approval I want to set it ...
1
vote
1answer
309 views
EOT and LOT vs EET and LET
Are the Earliest Occurrence time and Latest occurrence time same as the Earliest Event time and Latest event time or are they different? If they are different can you please explain to me what are EOT ...
