Hi there,

I am working on a large portfolio and there are about 45 projects running in parallel.
Each project is assigned to individual Project managers and each project has releases on monthly basis. I have to capture releases details on monthly basis and have to do the impact analysis by comparing with other project releases in the same month. A release can be added, deleted or moved to another month.

Currently, I am maintaining a spread sheet and put all releases details in it. I have to talk to each project managers to get these details and update the spread sheet. Rather I am updating this, I am thinking to store this document in a common folder and ask Project managers to update it. The problem is they may modify existing details in the document. The document should not allow do any changes on the existing details and only allow to add new rows.

In this case, One filed can be set as default and read only to understand what project managers have added . For example, A field is called “ Approved by Release Team” and this can be set as “NO” , in that way I know what have been added by Project Managers and I can change this filed to “YES” After I reviewing it.

And also I am concern about how multiple users can edit this document.

I am not sure how to add drop down fields. It would be great if you could help me on this.