Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Drop down List 1

Status
Not open for further replies.

VVAC123

Technical User
Nov 27, 2009
17
US
Hello I have a MPP that I want to add a column to that would be a custom drop down. is there a Formula to use looking at the start or finish date to see if the task is late or complete , I want a column that will have the following in a drop down list.

Not Started
In Progress
Complete


I would add a second custom list to a second column that would be

Red
Yellow
Green
Complete
Not Started
 
(1) Do you simply want two columns where you can arbitrarily select from a list of items for each task?

Or (2) do you want a formula that will make the calculations? If you want a formula to make the calculations then please answer the following:

column 1:
Not started
is this (2.1) %WorkComplete = 0
or this (2.2) %WorkComplete = 0 and Start < today

In progress
I presume (2.3) %WorkComplete >0 and %WorkComplete <100

Complete
I presume (2.4) %WorkComplete = 100


column 2:
2.5 Define the conditions for "red"
2.6 Define the conditions for "yellow"
2.7 Define the conditions for "green"
2.8 Define "Not Started" (see above)
2.9 for "red", "yellow", "green" do you want the words or do you want an image?

When you answer those 9 questions, I'll be able to help you.
 
Thanks in advance for your help
Column 1
Not Started
(2.2) %WorkComplete = 0 and Start < today
In Progress
2.3) %WorkComplete >0 and %WorkComplete <100
Complete
(2.4) %WorkComplete = 100

column 2:
2.5 Define the conditions for "red"
Behinde 30 days
2.6 Define the conditions for "yellow"
Behinde 1 week
2.7 Define the conditions for "green"
On Track with schedule
2.8 Define "Not Started" (see above)
< today's date
2.9 for "red", "yellow", "green" do you want the words or do you want an image?
Image
Thanks




 
Column 1: (I used Text1)
iif([% Work Complete]=0, iif([Start]<now(),"Starting Late","Not Started"), iif([% Work Complete]=100,"Complete","In Progress"))

column 2:
What do you mean by "behind"? Please use MS Project field names to explain your answer.

Your answer should (probably) refer to Start, Finish, Baseline Start, Baseline Finish, %WorkComplete (not necessarily all five)
 
PDQBach
Column2
Start, Baseline Start
Thanks
 
Column2: (I used Text2)
iif(DateDiff("D",[Baseline Start],[Start])>30,"RED",iif(DateDiff("D",[Baseline Start],[Start])>7,"YELLOW",iif([% Work Complete]=0,"Not Started","GREEN")))

RightMouseButton on the Text2 column header
Click on "Customize fields"
In the popup click on "Graphical Indicators..."

In the "Graphical Indicators for Text2" popup
Row1
Test: equals
Values: RED
Image: red balloon
Row2
Test: equals
Values: YELLOW
Image: yellow balloon
Row3
Test: equals
Values: GREEN
Image: green balloon
Row4
test: equals
values: Not Started
image: white balloon


I will leave it as an exercise for you to add the necessary code to handle Milestones.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top