Generate report from sheets created via Control Center


We have a number of projects provisioned by SCC, around 100+. We want to create a report to pull up all "Project Planning" sheets from these projects as source sheets. These projects are found across different workspaces. And we want that whenever a new project is created, the "Project Planning" sheet will be automatically added to the report as a source sheet. Is that possible? Can we do that on multiple reports?

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @Sabrina R.

    It sounds like you may want to take a look at this Help Article: About Dynamic Report Scope

    With a Dynamic Report in Control Center you can set up a Report that dynamically adds in a specific Sheet from your Blueprint every time a new project is provisioned:

    After you've set up the Report, then added it to the Blueprint that has your Project Planning sheet, Refresh the program to bring in all current sheets. If you need help going through these steps, I would recommend booking a Pro Desk session on Control Center to go through these steps on a coaching call: