formula -> get parent task

[bimki]

Hello,

I`m writting a formula to one text field.
is there any possibility to access to [parent task][Text6] field?

Thanks for any help!

 

[Jan De Messemaeker]

Hi Bimki,

Not through a fomula I'm afraid.
In VBA you can do that (the parent task is the OutlineParent object)
HTH

 

[Brian K - Project MVP]

Hello,

I`m writting a formula to one text field.
is there any possibility to access to [parent task][Text6] field?

Thanks for any help!

Here is the code that would do this.

It assumes that you want the child task Text6 to be equal to the parent
text 6 and that only Non-Summary tasks should get the value from their
parent.

Sub GetParentTextField()
Dim T As Task

For Each T In ActiveProject.Tasks
If Not (T Is Nothing) Then
If T.Summary = False Then
T.Text6 = T.OutlineParent.Text6
End If
End If
Next T
End Sub

--
___
Brian K
Project MVP
http://www.projectified.com

Project Server Consultant
http://www.quantumpm.com