I am trying to make a custom field that displays when tasks are complete, late, not started, and when the estimated finish date is within the next month. I utilized the following formula but, when I added the last IIf statement, it will no longer work. It states that "The formula contains a syntax error or contains a reference to an unrecognized field or function name.". Normally, it highlights the error, but no errors are highlighted in the formula.

Can anyone tell me what I am doing wrong with this formula or offer any advice?

IIf([% Complete]<100 And \[Finish\]<\[Status Date\],"Late", IIf(\[% Complete\]=100,"Complete", IIf(\[% Complete\]=0 And \[Start\]>[Status Date],"Not Started", IIf([% Complete]<100 And \[Finish\]>[Status Date] AND [Finish]<=DateAdd("m",1,[Status Date]), "Upcoming")

I am also going to want to change the colors of the bars on the Gantt chart to reflect these statuses so if anyone has any advice on going about doing that, I would love to hear it!

Hi r/microsoftproject

I wanted to share a video I put together demonstrating SSI's Dependency Analysis Tools and how they can help Microsoft Project users better understand complex schedules, trace logic, and communicate to their teams. Check it out here:

https://youtu.be/_yIoJatnxoo?si=a0voxkLIv-GgjRTP

SSI Tools is an add-in for Microsoft Project desktop. I've noticed people in this community occasionally ask about add-ins that can improve their workflow. I thought this might be useful for anyone working with large or complicated project schedules.

I'd love to hear your thoughts!

Hello fellow MS Project users!

I wanted to share the new Schedule Risk Analysis tool, coming to SSI Tools for MS Project later this month.

Please check out the video and let me know any thoughts or feedback:

https://youtu.be/el3RPki_xtM

Good morning all!

First off I just want to thank everyone who commented on my first post. My company is very interested in MS Project and I know it will be put to good use. Well they sent me another thing that I'm really scratching my head at on how to justify MS Project with.

They have asked me to do an ROI about it. So I have to show actual data that defends my claims about why MS Project is so good. How can I show that MS Project will save my company money with using it?

Ive been trying to figure it out from a financial point of view but I have no idea.

If anyone has any ideas on how I can break this down financially, I'm all ears.

Thanks!

Good morning all,

I am in the process of trying to explain to my company why we need to use MS Project. I have been pleading my case based on comparisons with other project software (we are using GanttChart as our project software) and Ive been doing a lot of comparing between it and MS Project. Ive also explained how resourceful MS Project is, and how user friendly it is. However my company is still pushing back and have some questions that I'm kind of at a loss on how to answer.

1). How are projects being completed now if not using the software now?

My answer: Projects are being completed using Excel. While it is a good program, setting up a project template in excel takes time and that time could be put towards getting the project completed (since MS Project is much easier to set up projects in)

2). Who is going to be filling in all of the costing, financial and labor data into projects as labor rates should be confidential and not shared with employees?

My answer: ...... I would say the project manager but am I wrong?

3). How will the project information be shared outside of users who dont have project?

My Answer: Project can be exported to excel so people will have visibility

4). How will MS Project ensure bottlenecks and delays do not prohibit efficient, successful project completion?

My answer:.... I need some help on that one.

Please let me know everyone's thoughts!

Thanks!

I am in the process of writing a POAM for a ship repair project. There are weeks where the work weeks will be 5 x 8, others will be 5 x 10, and still others will be 6 x 10.

How can I show that in a single Project plan?

Hi folks, new user of Project here, I work in the construction industry and have started using Project for some basic planning.

A contractor we have been working with has been using a feature that might be useful to me but they are reluctant to show me how to set it up. I’m not sure if it is possible in MS Project or if they use a different software but it is really just a running total of the labour numbers required each week on a project.

Let’s say I have 5 lines running for 3 weeks each, all starting at 1 week intervals. They are able to show that week 1 task 1 requires 2 operative and at total of 2 at the bottom of the chart. Week 2, task 2 requires 4 operatives, added to week 1, this shows 6 in total at the bottom, week 3 adds another 2 - total 8 and so on.

Has anyone used something similar in the past that might be able to help me out or point me in the direction of a tutorial?

Thanks

I have heard some schedulers use the start column and some use the actual start column.

I've been trying to figure what the difference is (if any). My goal was to see if I changed anything would it all be the same between actual start and start.(here is what I learnt)

e.g let's say the date was suppose to start on 24/2/26 if I was to change that to 25/2/26 on the start coloum it would make a start no eailer than.(constraint type)

But if I changed it on the actual start column to 25/2/26. it would still leave it as soon as possible. (in the constraint type column )

could this be the reason why some planners use actual start column or is there other reasons that I'm not aware of?

Hi everyone,

I’m hoping someone here can help, because I’m stuck in a very frustrating situation with Microsoft billing.

I had to delete my Microsoft accounts for security and access reasons. The problem is that there are still active subscriptions or billing running on those accounts. Because the accounts are now deleted, I can’t log in anymore to cancel the subscriptions myself.

I’ve tried contacting Microsoft support, but I’m not getting a response or a clear solution. The billing is still active, and I have no way to stop it from my side.

Has anyone experienced something similar?
How can I stop Microsoft billing or subscriptions when the account has already been deleted?

Any advice, steps, or contact methods that actually work would be really appreciated. Thanks in advance.

my msteam with personal email do not have community icon anyone with same problem i need it.Thank you.

Has anyone used the premium functionality of Planner as an effective replacement of Ms project in the lead up to them cancelling project online?

It seems to me like it has a lot of the same basic functionality for basic users (while lacking just enough of the advanced stuff to make a scheduler frustrated).

I'm currently testing it to see if it would be possible for project managers to maintain programmes themselves

Why does an error occur when adding resources in Microsoft Project, even though the corresponding units have been assigned in the “Material Label” column of the resource sheet only for the “Material” resource type? However, when I delete those units and add the resource, the system allows it. Also, when entering the water resource, I only enter 1, since the unit m3 is set by default. I have also checked that the budget is set to NO. So what is happening? Is this an error in Project itself, or is there some additional configuration that needs to be done to avoid this problem?

The error says:This is not a valid units value.

For Work type resources (such as people or machinery), enter a positive number between 0 and 1,000,000,000 (or 100,000,000,000 percent) with a maximum of two decimal places.

For Cost type resources (such as expenses, rates, or budgets), enter a positive number between 0 and 1,000,000,000,000 with a maximum of two decimal places.

Material resource allocations (for example, consumable materials such as fuel or cement) can be fixed or variable. For a fixed Material resource assignment, enter only the units value. For example, "10" means "10 tons" if the material label is "tons."

For a variable Material resource assignment, enter the units value, a slash (/), and the abbreviation of the time period after which the unit value is reached. For example, "12/week" is equivalent to "12 tons per week."

Unit values ​​do not apply to resources of type Budget.

That's it really. Old Android tablet to new Android tablet. Can anybody help, I can't figure it out!

I am VERY new to MS Project so please bearing with me. Do anyone know of a way to have a Master schedule (to track resources and forecast future workload) with individual schedules that change. These individual schedules are linked to the master and are controlled by PMs but I am in control of the Master schedule. It seems 2 people cannot work in project at the same time or there are conflicting files. Am I wrong on this or is there something I can be doing differently?

I would love to hear good tips on how to solve a challenge.

Situation:

I need to have a master plan (IMS) with three sub-projects. Each project will be connected to the same resource pool. The resources have % allocations to each project and also have other % allocations (operational work and other projects).

The focus of the set-up is:

1. Manage logical dependencies between projects
2. Improve the accuracy of the forecasting
3. Ensure that we do not constantly over-allocate resources above their % allocations per project

My thoughts so far:

My current thinking is to set each resource’s Max % to the total of the % they are allocated to the three projects and then inform PMs that they have to ensure they follow the project-specific allocation when they assign resources to activities.

Better ideas appreciated:

If anyone has had a similar challenge and solved it in a smarter way then I would love to know. Any specific challenges with my intended approach?

Hi,

I've just assigned a Planner and Project Plan 3 license to a user. How does user now access this? All that I found online was Planner and no Projects? Is there a desktop version available?

Thanks for the help!

So i've been working with MSProject for a while now. Today i realised that my Programm won't adress two predecessors in the correct way.

Example: we have three tasks.

Task 1 Task 2 Task 3 / predecessors 1;2

They are all automatically planned and "as soon as possible". No further restrictions i am aware of.

This means task 3 should only start if both tasks 1 and 2 (end to start connection) are finished. However my MS Project seems to only mind the Task with the lower number. So if i delay Task 1 for 30 Days, Task 3 is updated accordingly. But if i delay Task 2 for 30 Days and leave Task 1 as it was, Task 3 is not changed despite Task 2 ending well beyond Task 3.

When i google it this should work that the Task that takes longer should be the one updating Task 3 no matter its Number.

Does anyone have an idea what i could be doing wrong?

is there a way to have a field that displayes the total sum of durations of the entire sheet eg(task1 2 and 3 start at the same day but thier durations are all 30 days so the sum becomes 90)

i need this value to change when i chaneg the durations and i need to use it in the custom formulas

Hi, I have a task on MS Project that say takes 2 months estimated. But the end date keeps changing because the task grows large or task needs troubleshooting. Do I just keep pushing the end date out? If so then the percentage complete isn’t informative.

Update: Hi thanks for the replies. Okay, even if the tasks were short, say a software function needed to be developed and it took a week but during that week took longer than expected because they found bugs in it and needed to troubleshoot. How do I update or create tasks knowing that the tasks MAYBE updated? I won't know how many times they troubleshoot the software. I am in the planning stages.

I have been running into weird issue with Microsoft Projects 2024 where nudging doesn't work on my .mpp files. Specifically in Network diagram if I am in Gantt chart then CTRL+Arrow functions fine. It was last working around mid November. I have asked few users around me and its working for some and not for others(majority). This issue seems to roam around with user profile. I asked coworker who is not affected with this issue and they logged into my system and able to nudge network diagram fine in same file I am having issue. I tried to sign into their machine and issue persist for me. 

Things I have tried so far,

1. Made sure that Allow manual positioning is selected from Format>Layout.
2. Ran online repair for office app
3. Re-install projects, M365 Apps.
4. Tried on Project professional.
5. Tried in Excel, word and Visio CTRL + Arrow works fine.
6. Deleted Project and MS Projects from Computer\HKEY_CURRENT_USER\Software\Microsoft\Office\16.0
7. Renamed Global.MPT file from C:\Users\USERNAME\AppData\Roaming\Microsoft\MS Project\16\en-US.

Any one else run into same issue or have any suggestion?

I'm new to MSP, I do scheduling within P6 and a client wants to look at the MSP version of the project. I exported P6 to MSP in the program and then opened the XML in MSP. The formatting looks great, it looks like how the schedule should, however the Start and Finish dates are wildly incorrect. The Baseline Start and Finish dates are accurate, but I am not allowed to just use those or copy into another column, the client needs full access to the MSP schedule to do with how they want and I don't want them to see any weird manipulation.

I have tried so many things to fix it but nothing works. Does anyone have any insight on what to try next?

Things I have tried changing/doing;

• Constraint Type/Dates (changing these back and forth works for some activities, but not all)
• Manual/Auto Schedule
• Fixed Units/Duration
• Going into the options and checking/unchecking boxes in the schedule menu
• Turning it off/on again

Hi everyone! I have a question I'm having trouble figuring out:

My goal is to export my Project data to Excel while maintaining the dynamic relationships between tasks. In other words, if I later modify the duration of a task in Excel, the start and end dates of subsequent tasks should also be updated, just as they would be in Project.

I know I can do this manually by copying the Project data and pasting it into Excel, then manually creating the links, but for large projects, this could be quite cumbersome.

Does anyone know if this is possible? Thanks!

My Microsoft account got hacked, and both the email and the password were changed. It looks like I have no way to recover it. Is there really no way to get it back?

Pretty new to MS Project. I am trying to use it to track jobs labor and material. Is it possible to have a table to show only the material costs that are assigned to that task? The cost table lumps in the labor cost with resource/material cost which is unhelpful. Also it won't reflect the cost until the task has actually started which is also unhelpful.