Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

applying formula to summary only

Status
Not open for further replies.

hisbadbanana

IS-IT--Management
Oct 16, 2006
20
GB
i have a formula for a custom task field:
Code:
IIf([Number2]=4,IIf([Finish]<now()-14,"Yes","No"),"No")

is there a way to manipulate the above formula to also check whether it's a summary task?

thanks

-hisbad
 
This works in the Text1 field. If it's a summary task then Text1 contains "PDQBach".

Code:
IIf([Summary],"PDQBach",IIf([Number2]=4,IIf([Finish]<now()-14,"Yes","No"),"No"))

Remember, too, to set the radio button labeled "Use formula" (under "Calculation for task and group summary rows").
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top