Populating Reports from multiple sheets in a Workspace


We have a considerable number of sheets in a Workspace; identical structure for each, just different client.

Within each of those sheets, different users are assigned specific line items (tasks). A report is set up for each user showing the tasks from the various source sheets, that are assigned to that user.

At the moment we are manually adding the source sheets to the users' report. The risk of accidentally missing a sheet is high due to the number of sheets involved.

Can the users reports pick up all the data from within the Workspace rather than listing all the sheets?

Best Answers

  • Frank Falco
    Frank Falco ✭✭✭✭✭✭
    edited 03/04/20 Answer ✓

    You can add all the sheets in a workspace or folder by clicking on the icon but it will selected every sheet, so organizing the sheets you want to report on into folders may be worth considering. You still have to add new ones.

    ✅Did my post help 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!

  • TeeM
    TeeM ✭✭✭
    Answer ✓

    Thanks to both Andree and Frank🖐️