Milestone Tracking Report - Numerous projects

edited 12/09/19 in API & Developers
06/24/19 Edited 12/09/19

Hi all 

I'm trying to create a status report which would roll up project tasks and their progress into an easily view-able report and/or widget

The data will be across multiple sheets and I'm trying to find a way to trigger both active, complete and in progress data sets so that I can target the relevant stages inside of the report.

I have attached a screen shot of what I'm trying to get to- Hopefully it makes sense!

Screenshot 2019-06-24 at 14.59.26 - Display 1.png


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

    Hi Leah,

    How is the sheet(s) set up? You'd probably need to collect the information in another sheet (or columns on the same sheet) to get the structure that you want.

    Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

    Have a fantastic day!


    Andrée Starå

    Workflow Consultant @ Get Done Consulting


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

    W: | 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.

Sign In or Register to comment.