Custom Text Field?

[Sigmanut]

Doing a project that will be a template for many parts. Each part has a
Reference Information (RI) document file associated with it. I would like to
use the project Name or a field to substutite into the task list like this
useing a field description of [color]:
(example)
Red document your relults in C:\"Model "&[color]&" Reference Information"
Blue document your relults in C:\"Model "&[color]&" Reference
Information"

 

[Jack Dahlgren]

Sure.
Use one of the custom text fields.
You can store the "color" in the title or subject field for the project, or
you could put it in another custom field. Then just use something like this
for the formula:

"document your results in C:\" & [Subject] & " Reference Information"

-Jack Dahlgren

 

[Sigmanut]

Thanks Jack - Still trying.
I put ("document your results in C:\" & [Text1] & " Reference Information")
into the Task Name of a task.
Then went into Tools/Customize/Fields.
Selected the Custom Fields tab.
Set Type: to Text.
Went down to Custom Attrubutes and Selected Formula.
Put "Blue" in the text box
and Clicked 'OK' when I look at the task name, it still shows the formula.

I beg for another hint!

Sure.
Use one of the custom text fields.
You can store the "color" in the title or subject field for the project, or
you could put it in another custom field. Then just use something like this
for the formula:

"document your results in C:\" & [Subject] & " Reference Information"

-Jack Dahlgren

Doing a project that will be a template for many parts. Each part has a
Reference Information (RI) document file associated with it. I would like
to
use the project Name or a field to substutite into the task list like this
useing a field description of [color]:
(example)
Red document your relults in C:\"Model "&[color]&" Reference
Information"
Blue document your relults in C:\"Model "&[color]&" Reference
Information"

 

[Sigmanut]

I just looked at the Task Information. The custom fields tab shows Text1
value = Blue. Appears that the problem is in the formula. Ill keep looking.

Sure.
Use one of the custom text fields.
You can store the "color" in the title or subject field for the project, or
you could put it in another custom field. Then just use something like this
for the formula:

"document your results in C:\" & [Subject] & " Reference Information"

-Jack Dahlgren

Doing a project that will be a template for many parts. Each part has a
Reference Information (RI) document file associated with it. I would like
to
use the project Name or a field to substutite into the task list like this
useing a field description of [color]:
(example)
Red document your relults in C:\"Model "&[color]&" Reference
Information"
Blue document your relults in C:\"Model "&[color]&" Reference
Information"

 

[Jan De Messemaeker]

Hi,

Formulas only work in custom fields, so putting a formula in the Name field
is impossible
Also, you don't just type formuulas you an only enyter them through tools,
customize, fields etc.
HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Sigmanut]

Well, my interpertation of what you said leads me to believe that I need to
shift direction. What I'm trying to build is a template for a group of
projects.

I have 3 projects: Red Balloon, Blue Balloon & Green Balloon
Each project has 3 documents: Specs, Procedure & Tests
The end result is 9 documents:
C:\Red Balloon Specs.xls, L:\Red Balloon Procedure.doc, C:\Red Balloon
Tests.doc
C:\Blue Balloon Specs.xls, L:\Blue Balloon Procedure.doc, C:\Blue Balloon
Tests.doc
C:\Green Balloon Specs.xls, L:\Green Balloon Procedure.doc, C:\Green Balloon
Tests.doc
So, I would like my template to have something like this in a column:
(for Task 12) Document your work in C:\ & [project name] & " Balloon
Specs.xls"
(for Task 18) Document your work in C:\ & [project name] & " Balloon
Procedure.xls"
(for Task 33) Document your work in C:\ & [project name] & " Balloon
Tests.xls"

Then, when I use the template to create a project for Blue Balloons, I can
just set a [Project Name] variable to "Blue" and each of the tasks (12, 18
and 33) will show the correct document name.


Does this make sense as a practicle application within Project 2003?

Hi,

Formulas only work in custom fields, so putting a formula in the Name field
is impossible
Also, you don't just type formuulas you an only enyter them through tools,
customize, fields etc.
HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

Doing a project that will be a template for many parts. Each part has a
Reference Information (RI) document file associated with it. I would like
to
use the project Name or a field to substutite into the task list like this
useing a field description of [color]:
(example)
Red document your relults in C:\"Model "&[color]&" Reference
Information"
Blue document your relults in C:\"Model "&[color]&" Reference
Information"

 

[Jack Dahlgren]

Task name is not a custom field.
So this approach will not work if you want the task names this way.

-Jack

Thanks Jack - Still trying.
I put ("document your results in C:\" & [Text1] & " Reference
Information")
into the Task Name of a task.
Then went into Tools/Customize/Fields.
Selected the Custom Fields tab.
Set Type: to Text.
Went down to Custom Attrubutes and Selected Formula.
Put "Blue" in the text box
and Clicked 'OK' when I look at the task name, it still shows the
formula.

I beg for another hint!

Sure.
Use one of the custom text fields.
You can store the "color" in the title or subject field for the project,
or
you could put it in another custom field. Then just use something like
this
for the formula:

"document your results in C:\" & [Subject] & " Reference Information"

-Jack Dahlgren

Doing a project that will be a template for many parts. Each part has a
Reference Information (RI) document file associated with it. I would
like
to
use the project Name or a field to substutite into the task list like
this
useing a field description of [color]:
(example)
Red document your relults in C:\"Model "&[color]&" Reference
Information"
Blue document your relults in C:\"Model "&[color]&" Reference
Information"

 

[Jack Dahlgren]

Use a macro. This one below will ask you what name you want and will insert
the text on any task that is called "insert color name using macro".
Of course you can make this smarter if you like and it can name tasks and do
many other things (even putting a hyperlink to the document in the hyperlink
field.


Sub nameMyTasks()
Dim str As String
str = InputBox("enter the color name")
For Each Task In ActiveProject.Tasks
If Task.Name = "insert color name using macro" Then
Task.Name = "Document your work in C:\" & str & " Balloon Specs.xls"
End If
Next Task
End Sub

-Jack Dahlgren

Well, my interpertation of what you said leads me to believe that I need
to
shift direction. What I'm trying to build is a template for a group of
projects.

I have 3 projects: Red Balloon, Blue Balloon & Green Balloon
Each project has 3 documents: Specs, Procedure & Tests
The end result is 9 documents:
C:\Red Balloon Specs.xls, L:\Red Balloon Procedure.doc, C:\Red Balloon
Tests.doc
C:\Blue Balloon Specs.xls, L:\Blue Balloon Procedure.doc, C:\Blue Balloon
Tests.doc
C:\Green Balloon Specs.xls, L:\Green Balloon Procedure.doc, C:\Green
Balloon
Tests.doc
So, I would like my template to have something like this in a column:
(for Task 12) Document your work in C:\ & [project name] & " Balloon
Specs.xls"
(for Task 18) Document your work in C:\ & [project name] & " Balloon
Procedure.xls"
(for Task 33) Document your work in C:\ & [project name] & " Balloon
Tests.xls"

Then, when I use the template to create a project for Blue Balloons, I can
just set a [Project Name] variable to "Blue" and each of the tasks (12, 18
and 33) will show the correct document name.


Does this make sense as a practicle application within Project 2003?

Hi,

Formulas only work in custom fields, so putting a formula in the Name
field
is impossible
Also, you don't just type formuulas you an only enyter them through
tools,
customize, fields etc.
HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

Doing a project that will be a template for many parts. Each part has a
Reference Information (RI) document file associated with it. I would
like
to
use the project Name or a field to substutite into the task list like
this
useing a field description of [color]:
(example)
Red document your relults in C:\"Model "&[color]&" Reference
Information"
Blue document your relults in C:\"Model "&[color]&" Reference
Information"