Gannt Bar Formating Question

[Rob]

I found the below link in these discussion groups and I am trying to
incorporate this into My Project file for the very same reason as discussed
and the below link.

I cannot get this to work at all. I am using Project 2003 and I have
inserted a text column (Text 1) and I directly copy and pasted the below
formula from the below linked discussion. Nothing happened except that the
formula that I placed into the text field shows up but only as straight plain
text.

"w" & Format(DateAdd("d",7-Weekday([Finish]),[Finish]),"ww" & "'yy")

"w" & Format(DateAdd("d",7-Weekday([Finish]),[Finish]),"ww" & "'yy") & " "
& [Resource Names]

http://www.microsoft.com/office/com...ject&mid=9e5daeb2-93f4-438c-bcc5-9227508a17b1

I even tried my own with the below formula - (which is what I want to show);
&[Resource Names] & " - " & [% Complete]

Can someone please help me and explain what I am doing wrong?

Thanks Very Much In Advance,
Rob

 

[Jan De Messemaeker]

Hi Rob,

Project is not Excel!
You can't put formulas in cells.
Formulas are only possible for a field.
Tools, customize, fields, select the fiield you need, click Formula, paste
it there.
HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Mike Glen]

Hi Rob,

Welcome to this Microsoft Project newsgroup

You formula &[Resource Names] & " - " & [% Complete] will work if you
remove the first ampersand: [Resource Names] & " - " & [% Complete]

FAQs, companion products and other useful Project information can be seen at
this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for my free Project Tutorials

 

[Rob]

Excellent!! Thank you very much. It works great now!!!

Hi Rob,

Welcome to this Microsoft Project newsgroup

You formula &[Resource Names] & " - " & [% Complete] will work if you
remove the first ampersand: [Resource Names] & " - " & [% Complete]

FAQs, companion products and other useful Project information can be seen at
this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for my free Project Tutorials

I found the below link in these discussion groups and I am trying to
incorporate this into My Project file for the very same reason as
discussed and the below link.

I cannot get this to work at all. I am using Project 2003 and I have
inserted a text column (Text 1) and I directly copy and pasted the
below formula from the below linked discussion. Nothing happened
except that the formula that I placed into the text field shows up
but only as straight plain text.

"w" & Format(DateAdd("d",7-Weekday([Finish]),[Finish]),"ww" & "'yy")

"w" & Format(DateAdd("d",7-Weekday([Finish]),[Finish]),"ww" & "'yy")
& " " & [Resource Names]

http://www.microsoft.com/office/com...ject&mid=9e5daeb2-93f4-438c-bcc5-9227508a17b1

I even tried my own with the below formula - (which is what I want to
show); &[Resource Names] & " - " & [% Complete]

Can someone please help me and explain what I am doing wrong?

Thanks Very Much In Advance,
Rob

 

[Mike Glen]

You're welcome, Rob

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for my free Project Tutorials

Excellent!! Thank you very much. It works great now!!!

Hi Rob,

Welcome to this Microsoft Project newsgroup

You formula &[Resource Names] & " - " & [% Complete] will work if
you remove the first ampersand: [Resource Names] & " - " & [%
Complete]

FAQs, companion products and other useful Project information can be
seen at this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for my free Project Tutorials

I found the below link in these discussion groups and I am trying to
incorporate this into My Project file for the very same reason as
discussed and the below link.

I cannot get this to work at all. I am using Project 2003 and I
have inserted a text column (Text 1) and I directly copy and pasted
the below formula from the below linked discussion. Nothing
happened except that the formula that I placed into the text field
shows up but only as straight plain text.

"w" & Format(DateAdd("d",7-Weekday([Finish]),[Finish]),"ww" & "'yy")

"w" & Format(DateAdd("d",7-Weekday([Finish]),[Finish]),"ww" & "'yy")
& " " & [Resource Names]

http://www.microsoft.com/office/com...ject&mid=9e5daeb2-93f4-438c-bcc5-9227508a17b1

I even tried my own with the below formula - (which is what I want
to show); &[Resource Names] & " - " & [% Complete]

Can someone please help me and explain what I am doing wrong?

Thanks Very Much In Advance,
Rob