Drop down List 1

[VVAC123]

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

 

[PDQBach]

(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.

 

[VVAC123]

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

 

[PDQBach]

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)

 

[VVAC123]

PDQBach
Column2
Start, Baseline Start
Thanks

 

[PDQBach]

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.