Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-09-2011, 06:56 AM
Antares Antares is offline Groups to be sorted by start date in MS Project Windows XP Groups to be sorted by start date in MS Project Office 2007
Novice
Groups to be sorted by start date in MS Project
 
Join Date: Aug 2011
Posts: 17
Antares is on a distinguished road
Default Groups to be sorted by start date in MS Project

Hi,



I have rearranged my tasks so that they are grouped according to some parameter - Let's say I "custom grouped" them location-wise.

And these groups are listed in alphabetic order either ascending or descending...
but i need them (groups) to be sorted start date-wise...

Can you advise me how to do it...

Thanks much
Reply With Quote
  #2  
Old 12-09-2011, 10:54 AM
JulieS JulieS is offline Groups to be sorted by start date in MS Project Windows 7 64bit Groups to be sorted by start date in MS Project Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

You'll need to do a 2 level group. First group by date and then by location or group by location, then by date.

If you group first by date, you can select under "Define Group Intervals" to have it group by value (individual date) or by week or month.

I hope this helps.

Julie
Reply With Quote
  #3  
Old 12-09-2011, 01:27 PM
Antares Antares is offline Groups to be sorted by start date in MS Project Windows XP Groups to be sorted by start date in MS Project Office 2007
Novice
Groups to be sorted by start date in MS Project
 
Join Date: Aug 2011
Posts: 17
Antares is on a distinguished road
Default Groups to be sorted by start date in MS Project

Dear Julie thank you for your kind responses which help me much....
but I couldn't understand well what should I do to sort my groups start date-wise.

Let me reformulate my question uploading sample file:

Suppose my tasks are grouped location-wise: locations A, B, C, in the ascending order (like in the attached file).
But if you see you will notice that start order is following: first starts group C than group A and finaly group B, so Id like to have my groups' order to be: C,A,B,
So is it possible to have such arrangement?

Thaaanks
Attached Files
File Type: zip Group question.zip (24.8 KB, 5 views)
Reply With Quote
  #4  
Old 12-09-2011, 03:17 PM
JulieS JulieS is offline Groups to be sorted by start date in MS Project Windows 7 64bit Groups to be sorted by start date in MS Project Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Hi Antares,
Sorry, I don't think that will be possible. Project wants to sort your group alphabetically, which is why it is using A, B, C. It keeps the location tasks together because they have the same value. It doesn't know anything about the dates as you've not included those in the group definition.

If you group first by location, then by date, you can produce a more logical flow -- but if two tasks have the same start date, it will group then by location.
Attached Images
File Type: png snip.PNG (50.3 KB, 1 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Groups to be sorted by start date in MS Project MS Project Start Dates not matching the Status Date sjodom Project 3 12-04-2011 08:45 AM
Groups to be sorted by start date in MS Project Need advice on category sorted e-mail merge GeoB Mail Merge 3 09-08-2011 11:03 PM
Groups to be sorted by start date in MS Project Project start date steve138 Project 4 05-20-2011 04:55 AM
Groups to be sorted by start date in MS Project Lookup a value from non-sorted data udea Excel 12 04-25-2011 04:34 AM
MS Project able to import actual start and or actual finish date from Excel? mhacker Project 0 04-26-2010 11:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:00 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft