A Flag Question

[BobC]

Using 2003 on a server.
I have created a flag in a Text Field using the following expression to
test for 4 situations with regard to dates:

IIf(([Actual Start]<>projdatevalue("NA") And [Actual Start]>[Enterprise
Project Date1])Or ([Start]<[Enterprise Project Date1] And [%
Complete]="0") Or ([Start]<[Enterprise Project Date1] And [%
Complete]<>"100" And [Resume]<[Enterprise Project Date1]) Or([Actual
Start]< [Enterprise Project Date1] And [Stop]>[Enterprise Project
Date1]) ,"Y","")

The flag works fine for the various subtasks. I would like for the flag
to roll up (or show up) to the Summary line if there is a flag on one of
the subtasks (so it is obvious if the Summary task happened to be
collapsed.

Suggestions please?
Bob

 

[Dale Howard [MVP]]

Bob C --

Click Tools - Customize Fields and select the field containing the formula.
Select the "Use formula" option in the Calculation for Task and Group
Summary Rows section of the dialog. Click OK to finish. Selecting this
option applies the formula to summary tasks. Hope this helps.

 

[BobC]

I will try it tomorrow (at work).
My main concern is that I do not think the same equation will always
apply the same at the summary row level??

 

[BobC]

I very much appreciate your help. This is what I wrote (ms word) in my
documentation:
Consists of 4 Tests:

1) [Actual Start]<>projdatevalue("NA") And [Actual Start]>[Enterprise
Project Date1]
[Start Date is in the Future]

2) [Start]<[Enterprise Project Date1] And [% Complete]="0"
[Task is Started in the Past with 0 progress]

3) [Start]<[Enterprise Project Date1] And [% Complete]<>"100" And
[Resume]<[Enterprise Project Date1]
[Progress is NOT updated as scheduled]

4) [Actual Start]< [Enterprise Project Date1] And [Stop]>[Enterprise
Project Date1]
[Shows progress beyond the Status Date]

Thanks Again!
Your help is appreciated!
Bob