Roll-Up Project Tracking Tool

This forum is for members to share and gain knowledge of Project Management. Got a question about project management? Need help with a problem? Wish to offer tips and advice? Post here.
Post Reply
jasonw425
New Member
New Member
Posts: 1
Joined: Wed 15 Jan 2020 11:15 pm

Hello All,

I thought I posted this yesterday but I don’t see it, so here I go again.
I’m tasked with consolidating information from several projects and teams into one single source, a department resource/project tracker. However, each team and project want some level of autonomy when tracking their own project statuses. I understand this and I have a solution in my head, but I cannot find the right software to implement this.

My idea is to have each team have its own tracker, however the first 5 or 6 columns are standardized. For example:

All teams would have the first 5 columns set up like this:
  • Project name
  • Project description
  • Status
  • Quality Record Number (i.e. CAPA)
  • Responsible Person
After that, they can make as many columns as they would like and track what ever they feel the need to. All I care about is those first 5 fields. Each team’s tracker (the first 5 columns) would automatically populate into a main tracker.
The challenge is the cells would cannot be static. As projects are added and removed the cells may move. I also don’t want to have to have people enter the project information twice, their tracker and the main tracker.
I’ve tried this on Smartsheet, but it didn’t work well. It felt clunky and it required too much human intervention.
If I haven’t thoroughly confused you yet, I’d really appreciate some feedback on this.

Thanks
Jason
Post Reply