Report that takes data from multiple workspaces

04/08/21
Answered - Pending Review

Hello everyone,

Do you know if we can create a report that would go into all our workspace, or that each time I create a new workspace it takes it into account ? (just like you would do when you choose a single workspace, the report takes into account all sheets from the workspace).

Maybe it is possible with Control Center ?

It is very important for us as we have a workspace for each client (300) with multiple projects in each workspace, and we need to create reports that go and look for a lot of data in all client workspaces.

Thank you for your help,

Corentin

Answers

  • Bassam.M KhalilBassam.M Khalil ✭✭✭✭✭

    Hi @Corentin Dal Farra 

    Hope you are fine, did you mean you want to collect data for a defined client from the specific workspace using all the sheets in that workspace. 

    Best Regards

    Bassam.M Khalil


    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as the accepted answer. It will make it easier for other Smartsheet Community members to find this solution or help to answer their questions.

  • Corentin Dal FarraCorentin Dal Farra ✭✭✭✭✭

    Hi @Bassam.M Khalil

    For example I have 3 different clients workspace with 3 project sheets in each client workspace.

    I would like the report to automatically go into the 9 project sheets.

    Let me know if it is more clear,

    Thank you for your help,

    Corentin

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi @Corentin Dal Farra

    I hope you're well and safe!

    The only way I can think of would be with Control Center or maybe the Smartsheet API.

    Would that work/help?

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • Corentin Dal FarraCorentin Dal Farra ✭✭✭✭✭

    Hi @Andrée Starå

    Could you please explain me how to do this with Control Center ?

    For example I have created a report that goes into the client workspaces already existing, but each time I create a new client workspace through control center the report does not take into account the new workspace created.

    Thank you for your help,

    Corentin

Sign In or Register to comment.