?
Solved

MS Project 2002 Add Custom Field

Posted on 2010-11-24
2
Medium Priority
?
876 Views
Last Modified: 2013-11-15
Hello,

I know relatively nothing about MS Project but have a user who needs some modification done to this file and has no other resources, figured since I know MS Excel fairly well I might be able to help.  They would like to create a custom field using a conditional formula based on other existing fields at task level.  The existing fields are the start/end date and percetage complete.

Here is what they essentially are looking for:  A new column to be added after the status column that will allow them to filter and see incomplete tasks.  This needs to be based on the following parameters:
1. If the task is completed, ignore the task
2. If the task is late, show regardless of date.
3.  If the task is within 2 weeks of scheduled completion, show the task.

Therefore, on the attached sample file, rows 3 & 4 would be ignored since they are already completed.  Rows 5-6 would show since they are late.  Rows 7-10 would show since they are within 2 weeks of todays date.  Rows 11-14 would not show since they are future tasks beyond 2 weeks of todays date.  I have a sample file but cannot get it to load in EE due to the file extension so I'll post an image instead.

Can someone please assist in putting something like this together?

Thanks!
MS-Project.jpg
0
Comment
Question by:Escanaba
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 4

Accepted Solution

by:
EFernandes earned 2000 total points
ID: 34207032
If I understood correctly, this should help you: http://blogs.techrepublic.com.com/tech-manager/?p=3309 
0
 
LVL 1

Author Closing Comment

by:Escanaba
ID: 34230963
Thanks!
0

Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

At the office, we’ve started to get serious about organizing what we’re doing. I mean, it was getting to the point where every time I received a phone call, it began with “I know you’re really busy, but…” My boss was taking tasks away from me left a…
Re-planning is just as important as planning. MS Project files need to be updated regularly to reflect the current status of the project and to streamline the upcoming tasks. We have seen a lot of issues where project managers have not updated the p…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question