MS Project：在自定义字段公式中引用特定任务中的字段 [英] MS Project: Referencing field in specific task within the custom field formula

问题描述

嘿，

我正在尝试在MS项目2007中设置项目（遗憾的是升级不是一个选项:(）。我的情况如下：

I am trying to setup a project in MS project 2007 (upgrading is unfortunately not an option :( ). my situation is as follows:

任务＃12有一个自定义文本字段，[Text30]，它将包含1或0.我正在尝试创建一个新的自定义字段（对于任务＃13），[Duration1]  这是基于特定任务＃12的[Text30]的值的条件。是否有一个语法
引用特定任务的字段值？ 

task #12 has a custom text field, [Text30], that will either contain a 1 or a 0. I am trying to create a new custom field (for task #13), [Duration1]  that is conditional based on the value of [Text30] for specifically task #12. Is there a syntax to reference the field value of a specific task? 

对于ex>>   IIf（[Text30] = 1,1 d，0 d）将仅引用它也在其上的任务的[Text30]。我正在寻找要做的事情的语法行：  IIf（Task12。[Text30] = 1,1 d，0 d）或IIf（Task12 {[Text30]} = 1,1 d，0 d）这样的
表示这个条件值将始终相同且仅基于[Task12]的[Text30]

for ex >>  IIf([Text30]=1,1 d,0 d) will only reference [Text30] of the task that it is also on. I am looking for the syntax to do  something along the lines of: IIf(Task12.[Text30]=1,1 d,0 d) or IIf(Task12{[Text30]}=1,1 d,0 d) such that the condition of this value will always be the same and based only off [Text30] of [Task12]

如果可能，请告诉我....

Please let me know if this is even possible....

~Ben

作为参考，

我正在尝试创建一个"gate&q" UOT;可以这么说......如果任务12（通过或失败检查）失败，则所有里程碑和任务在崩溃后变为0d并标记为100％完成（即如果门失败则切断部分项目）
是否应该通过持续时间，其他任务的完整性将保持不变。

I am trying to create a "gate" so to speak... such that if task 12 (a pass or fail check) fails then all of the milestones and tasks after it collapse to 0d and get marked 100% complete (ie cutting off parts of the project should the gate fail) should it pass the duration and completeness of the other tasks are to be unchanged.

推荐答案

Ben，

抱歉，任务自定义字段公式只能引用同一个任务和一些项目字段中的其他字段。 使用vba做你喜欢的事情会很简单，但具体细节取决于任务12和任务13之间的关系。 对于您的特定应用程序
，vba还提供了能够直接操作计划（即前任，后继，持续时间）的关键优势，哪些自定义字段无法执行。

Sorry, task custom field formulas can only reference other fields in the same Task and a few Project fields.  It would be simple to do what you like using vba, though the exact details depend on the relationship between task 12 and task 13.  For your particular application, vba also provides the key benefit of being able to directly manipulate the schedule (i.e. predecessors, successors, duration), which custom fields can't do.

祝你好运，汤姆 

Good luck, tom 

这篇关于MS Project：在自定义字段公式中引用特定任务中的字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！