Creating a custom formula with two peices of data

[lazarus long]

Hi, new project user here trying to figure out how to create a formula that
does what i want.

Rght now i have 'DateDiff("d",[Start],[Finish])+1' in the 'Text1' field to
show me the calander duration of a project.

I want this to also include the information in my Task Name collum, so I can
have the calander duration and the task name show in the top level roll up on
the Gnatt

How would i write this forumla?

thanks!

 

[Jan De Messemaeker]

Hi,

First, you cannot write a formula in the task name column itself, you will
have to write one in a text field
It could look like [Name] & [Text1]
HTH

 

[lazarus long]

Thanks, got the formula i need. Is there a way i can insert a space between
[Name] & [Text1]?

 

[Jan De Messemaeker]

[Name] & " " & [Text1]

 

[lazarus long]

thank you so much for your help

scott

[Name] & " " & [Text1]

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm

Thanks, got the formula i need. Is there a way i can insert a space between
[Name] & [Text1]?