Custom Formula

[JudithJubilee]

Hello there,

I am creating some custom fields to export into Excel. I would like a field
that has the text Summary or Milestone next to the relevant tasks. I have
written the following formula:

IIf([Summary]=Yes,"Summary",iif([Milestone]=Yes,"Milestone",""))

The Milestones work but I am getting a blank for the Summary tasks.

Any help is appreciated

Judith

 

[JulieS]

Hi Judith,

In the Customize Fields dialog box where you set the original formula,
click the option button "Use Formula" under the section "Calculation for
task and group summary rows". That should now set the summary rows to
calculate.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project