Hi Cris,
You're welcome Cris and thanks again for the feedback. To your question
about a list, the good news is yes, it can be done and I doubt it will be
pushing your brain limits too far -- you are doing great thus far!
The steps:
In the table portion (left side of Gantt chart), select a column and choose
Insert > Column from the menu to display the Column Definition dialog box.
In the Field Name drop down select Text1. I would supply a title of
"Phase". Align the title as needed and I would align the data to the left.
Click OK to close the Column Definition dialog box.
Right click on the "Phase" column and select Customize Fields from the
shortcut menu to open the Customize Fields dialog box. (The Text1) field
should be selected in the Custom Fields list.
Click the Rename button to open the Rename Field dialog box and enter
"Phase".
Click OK to close the Rename Field dialog box and return to the Customize
Fields dialog box.
In the Customize Fields dialog box, click the Value List... button to open
the Value List for "Phase" dialog box.
Enter in your values (one per line) -- for example: Millwork, Metal etc.
If you would like you can select one of the values and click the "use a
value from the list as the default entry" check box then click the Set
Default button.
Make your selections as far as Data Entry Options and the display order.
Click OK to close the Value List for "Phase" dialog box.
You'll get a message from Project about invalidating some data.
Click OK to make the change and return to the Customize Fields dialog box.
Click OK to close the Customize Fields dialog box.
You've now created your value list that you can select one of the phases
from without having to type.
To follow along with FAQ 31 about customizing the Flag1, Flag 2
fields --because flags only have 1 of 2 possible values (no or yes) you'll
need to add as many flag fields as you have phases. Insert a flag field for
each phase (Flag1, Flag2 etc.)
You'll customize each Flag field to check for the desired value in the
"Phase" field and display "yes". Right click on the Flag field choose
Customize Fields and this time select the Formula button.
For a Flag field to test for Millwork in the Phase field, the formula would
be:
IIf([Phase] = "Millwork", yes, no)
This will change the Flag field to yes if the text in the "Phase" field
equals Millwork, otherwise it will remain no.
Be careful to enter the formula using the exact capitalization and spelling
of the value in the "Phase" field.
Repeat for each Flag field modifying the formula to look for each other
value.
I hope this helps. Let us know how you get along and be sure to post back
with any further questions.
Julie
raydeo said:
Thanks Julie, once again!!! And thanks to the others who answered my
question yesterday!!!!!
Now another question relating to the rest of them. This may be getting a
little advanced for me, but what the heck!!! Can I create a column called
"Phase" and make it a drop down list where I can select the appropriate
phase? If this can be done so that I am not having to type in each phase
everytime, can the formula in the first column that I created be edited so
that it has a response to each different phase? I know that this is
pushing
the limits of my brain, but is it pushing the limits of project?
Thanks again everyone for your help!!!!!
Cris