none
Creating customized Resource Allocation view in Sharepoint

    Frage

  • Hello All,

    I want to create a customized view as below that has each week's resource allocation for each project in 2 locations. The rows would be the project name and each project would have two locations(NYC and SFO) along with allocation for NYC and SFO. The two managers in these locations would be maintaining two different sharepoint lists where they enter the start date, project name and the resources allocated to the project for that week. So my job is combine those 2 sharepoint lists and create the below view. For each new project added in the managers sharepoint list, it should create a new row in this view and display the allocation details. I'm facing problems in creating the dynamic rows while combining the lists. Please let know if this is possible in Sharepoint or I'll have to use some other tool.The Overall row should be at the end and any new project should be added in the row above Overall. Please let me know if this is feasible in Sharepoint.

    Project Name

    Locations

    Jul 2

    Jul 9

    Jul 16

    Jul 23

    Jul 30

    Aug 6

    Aug 13

    Aug 27

    9.1 Regression

    NYC

    12

    10

    SFO

    3

    4

    Merge UAT

    NYC

    5

    SFO

    1

    1

    1

    1

    1

    Req. Capacity

    NYC

    17

    10

    SFO

    4

    5

    1

    1

    1

    Overall

    21

    15

    1

    1

    1

    Available Cap.

    NYC

    SFO

    Thank you.

    Rohit B Pillai


    Freitag, 22. Juni 2012 16:46

Antworten

Alle Antworten