none
How to set multiple start/end dates for a calendar or gantt view? RRS feed

  • Question

  • Sharepoint 2007:

    In my list, I have multiple items from the same project. Each item has a start and end date (but not in the same columns). For example, I have:

     

     

    Is there any way to make a gantt or calendar view in Sharepoint 2007 where I can have multiple start and end dates? (as of now, I can only set a calendar to show two dates --ex: dept. 1 start and end dates, which doesn't let me see the visual time progress for the whole projects/all departments). Any Suggestions??

    Project Dept1 Start Date Dept1 End Date Dept2 Start Date Dept2 End Date Dept3 Start Date Dept3 End Date
                 
    Project 1 1/2/2011 1/4/2011        
    Project 1     1/6/2011 1/9/2011    
    Project 1         2/2/2011 2/9/2011
    • Edited by Mike Walsh FIN Thursday, March 3, 2011 8:20 AM Sharepoint 2007: default so moved from Title to text
    Wednesday, March 2, 2011 3:59 PM

Answers

  • How would you see the visual time progress for the whole projects/all departments? What if there's a gap between the "Dept1 End Date" and the "Dept2 Start Date"? Just trying to picture the end result.

    As far as I know, out of the box you can't use multiple start/end dates to create gantt view. You could create a separate view to show overall progress that uses the actual dates. For example, in your case start date would be Dept1 Start Date and end date would be Dept3 End Date.

     


    Pman
    http://www.pmansLab.com/
    • Marked as answer by Peng Lei Tuesday, March 8, 2011 7:50 AM
    Thursday, March 3, 2011 2:23 AM

All replies

  • How would you see the visual time progress for the whole projects/all departments? What if there's a gap between the "Dept1 End Date" and the "Dept2 Start Date"? Just trying to picture the end result.

    As far as I know, out of the box you can't use multiple start/end dates to create gantt view. You could create a separate view to show overall progress that uses the actual dates. For example, in your case start date would be Dept1 Start Date and end date would be Dept3 End Date.

     


    Pman
    http://www.pmansLab.com/
    • Marked as answer by Peng Lei Tuesday, March 8, 2011 7:50 AM
    Thursday, March 3, 2011 2:23 AM
  • Bean244,

    This may be late but here is what i'm currently doing

    I have a list that collects the following information

     Project Number

     Name 1

     Start Date 1

     End Date 2

     Name 2

     Start Date 2

     End Date 2

     1

     Rick

     03/30/2011

     04/11/2011

     Mark

     04/28/2011

     05/05/2011

     

    Create a workflow in SPD that will populate a 4 column consolidated list.. this is the list you will use to build your gantt chart

    Project Number

    Name

    Start Date

    End Date

    1

    Rick

    03/30/2011

    04/11/2011

    1

    Mark

    04/28/2011

    05/05/2011

    That should work for your gantt chart.

     

    Friday, April 29, 2011 9:39 PM