Combining Data from Multiple Sheets

Hi All

I am having 8 different project-sheets and each project has some common tasks (like "Design Status").

Now I want to be able to count the Design Status from all the projects whose value is "ready", and after counting I want to display this count on the dashboard so that I know how all my projects are progressing.

Please help!

Thanks

Nasir

Answers

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

    Hi Nasir,

    There are a few different ways to structure it. Here are a few suggestions.

    • Create a Master Metric sheet and use cross-sheet formulas to calculate everything together.
    • Same as above with the calculations done on each sheet and then cell-linked to the Metric sheet.

    What do you think?

    Would that work?

    I hope that helps!

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    ✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. 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:[email protected] | P: +46 (0) - 72 - 510 99 35

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