RussEaglin
Technical User
Need to add a column for Status that color codes it to Red/Yellow/Green. Wanting to make the decision on R/Y/G myself rather than formula.
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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Help on assigning Red/Yel/Green status to tasks 1
- Thread starter RussEaglin
- Start date
- Status
-
1
- #2
That's pretty easy to do...
First insert a new "text" type column into your plan. Right click on the column to open the "customize field" and then choose rename to make it something like "Status". Under "Custom Attributes" choose formula and enter your criteria and give it a numerical resultant value. Then click on the "Graphical indicators" button and define Test to be "equals" then the value, such as 1, and then choose the icon you'd like to dsiplay for that particular value.
For example, one of the formulas I have is...
"IIf([% Complete]<100 And [Finish]<[Current Date],0,IIf([% Complete]<75 And ([Finish]-14)<[Current Date],2,1))"
Hope this helps you out.
Zen
First insert a new "text" type column into your plan. Right click on the column to open the "customize field" and then choose rename to make it something like "Status". Under "Custom Attributes" choose formula and enter your criteria and give it a numerical resultant value. Then click on the "Graphical indicators" button and define Test to be "equals" then the value, such as 1, and then choose the icon you'd like to dsiplay for that particular value.
For example, one of the formulas I have is...
"IIf([% Complete]<100 And [Finish]<[Current Date],0,IIf([% Complete]<75 And ([Finish]-14)<[Current Date],2,1))"
Hope this helps you out.
Zen
zencalc's answer works but RussEaglin said "Wanting to make the decision on R/Y/G myself rather than formula".
So ...
Insert column Number1
RightMouseButton on the column title and click "Customize fields". You'll get a popup window.
At the bottom of the popup, click "Graphical indicators". You'll get a second popup window.
In the popup on the first row:
== Test for Number1: equals
== Values: 1.00
== Image: choose the green ball.
In the popup on the second row:
== Test: equals
== Values: 2.00
== Image: choose the yellow ball.
You can guess what you do on the third line.
Click on OK twice to close the popups.
Now, for any given task, in the Number1 column enter 1 or 2 or 3 to see the G/Y/R balls. Leave it blank and the cell remains blank.
So ...
Insert column Number1
RightMouseButton on the column title and click "Customize fields". You'll get a popup window.
At the bottom of the popup, click "Graphical indicators". You'll get a second popup window.
In the popup on the first row:
== Test for Number1: equals
== Values: 1.00
== Image: choose the green ball.
In the popup on the second row:
== Test: equals
== Values: 2.00
== Image: choose the yellow ball.
You can guess what you do on the third line.
Click on OK twice to close the popups.
Now, for any given task, in the Number1 column enter 1 or 2 or 3 to see the G/Y/R balls. Leave it blank and the cell remains blank.
- Status