Sort

[glen.e.mettler]

Using 2003 - I have searched the newsgroup but can't find exactly what
I need regarding sort.
Situation:
Summary A 3/1/06 - 12/1/06
Summary B 1/1/06 - 11/1/06
Summary C 2/1/06 - 2/2/07

Summary N x/x/xx - y/y/yy

I have many tasks under each summary. I want to sort the subtasks by
date but I want to keep the sort order of A, B , C...N. In other
words, I want ot waterfall the tasks within each summary by date but I
don't want to sort the summaries.

How can I do that?

Glen

 

[Jan De Messemaeker]

Hi,

Insert a number column, say Number1
Copy the id of summary tasks to Number1
Now sort by Number1, thenby Start, Keep Outline Structure.
HTH

 

[glen.e.mettler]

Jan,
Thanks. I did that manually and it works just fine. I wanted to do
that with a formula in Number1 but it doesn't seem to work. Here is
what I put in Number1 _

IIf([Summary]="Yes",[ID],0)

I selected "Use Formula" for summary rows

What have I done wrong?

Glen

 

[Jan De Messemaeker]

Hi,

Summary is a true/Faslse field in itself so
IIf([Summary],[ID],0)

does it.
HTH
--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade

Jan,
Thanks. I did that manually and it works just fine. I wanted to do
that with a formula in Number1 but it doesn't seem to work. Here is
what I put in Number1 _

IIf([Summary]="Yes",[ID],0)

I selected "Use Formula" for summary rows

What have I done wrong?

Glen

Hi,

Insert a number column, say Number1
Copy the id of summary tasks to Number1
Now sort by Number1, thenby Start, Keep Outline Structure.
HTH

 

[glen.e.mettler]

Of course!! Thanks

Glen

Hi,

Summary is a true/Faslse field in itself so
IIf([Summary],[ID],0)

does it.
HTH
--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade

Jan,
Thanks. I did that manually and it works just fine. I wanted to do
that with a formula in Number1 but it doesn't seem to work. Here is
what I put in Number1 _

IIf([Summary]="Yes",[ID],0)

I selected "Use Formula" for summary rows

What have I done wrong?

Glen

Hi,

Insert a number column, say Number1
Copy the id of summary tasks to Number1
Now sort by Number1, thenby Start, Keep Outline Structure.
HTH

--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade
Using 2003 - I have searched the newsgroup but can't find exactly what
I need regarding sort.
Situation:
Summary A 3/1/06 - 12/1/06
Summary B 1/1/06 - 11/1/06
Summary C 2/1/06 - 2/2/07

Summary N x/x/xx - y/y/yy

I have many tasks under each summary. I want to sort the subtasks by
date but I want to keep the sort order of A, B , C...N. In other
words, I want ot waterfall the tasks within each summary by date but I
don't want to sort the summaries.

How can I do that?

Glen