Can I apply a fomular in entry table fields?

[åŠæ–°ä¸æ—§]

Hi, can I apply a formular in "Publish" field of Gantt Entry Table such as
Publish='Yes' if %Completed='100%'?


Thanks in advance,

JJin

 

[Jan De Messemaeker]

Hi,

As a general rule, you can only have a formula in a custom field, never in a
"native" Project field
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[åŠæ–°ä¸æ—§]

Thanks Jan, in case of I want to automatically set <publish> field= "no" for
all 100% completed task, do you have any suggestion for implementing that
request?

JJin

 

[Jonathan Sofer [MVP]]

The most common way to do this is using VBA macros.

 

[Jonathan Sofer [MVP]]

The most common way to do this is using VBA macros.

 

[Mike Glen]

Jonathan, can you review your posting process as we seem to be getting two
of each of them

Mike Glen
Project MVP

 

[åŠæ–°ä¸æ—§]

Hi, Jonathan, could you please give a sample macro for this request?
Thanks in advance,

JJin

 

[Jonathan Sofer [MVP]]

Here you go JJin,

Sub SetPuplishedToNoForCompletedTasks()
Dim t As Task

For Each t In ActiveProject.Tasks
If Not (t Is Nothing) Then
If t.Summary = False And t.PercentComplete = 100 Then
t.IsPublished = "No"
End If
End If
Next t
End Sub

You might want to implement this so it is called on the save or publish
event or train your users to call this subroutine after they update their
schedules.

Hope this helps, Jonathan