I am trying to develop a dashboard generator so that I don't have to recreate every report I use in our dashboards each time we have a new project.  I would like to be able to select the project number in one location and have all the reports reference that project number to pull data from their respective sources, then these reports would populate the project specific dashboard.  Any thoughts on how to make that happen?

I currently have the data for our company structured so that there is a sheet for each type of data and that sheet contains that type of data for all project (not a sheet per project).  For example, all issues are tracked in one sheet which can be filtered by project number; all submittals are tracked in another sheet which can be filtered by project.


Hi Ross,

Interesting, I have a few ideas, and I'd be happy to take a look.

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic week!


Andrée Starå

Workflow Consultant @ Get Done Consulting