How to pull assigned task from differnt workspaces into a master task sheet

Each of my clients has their own workspace with multiple sheets. One of the sheets is a project planner/task list, where each task is assigned to an employee. We have 50 + clients and you have to go into each workspace and click on the project planner/task sheet to keep up with what is assigned to you. Is there a way to create a "master" sheet for each employee that will pull in everything that is assigned to them? I would also like for them to be able to make updates in their individual "master" sheet that will then automatically update the individual client's sheet. 

Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    edited 07/07/20

    Hi Deby,

    I’d recommend using a report instead. You could use the Current User feature so the one looking at the report would only see their tasks.

    Would that work?

    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 EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.