Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

What reports are most useful to you?

Terri Pavlovic
Terri Pavlovic ✭✭✭
edited 12/09/19 in Archived 2015 Posts

I'm looking for some input on what reports you've found most useful. 


We've been using Smartsheet for about a month for 12 projects run by 3 PMs.  The project plan functionality is working great.  We are just getting going with reporting.


Here are the initial reports I'm planning:


- Individual "Look Ahead" Task Lists for each resource

- Overdue Task Report

- Project Roll-Up Report (summary status info on all projects)


I'm also looking to do something on resource management, but without effort-based (% allocation) info, it may not be as useful.


Any other suggested reports?




  • Tim Meeks
    Tim Meeks ✭✭✭✭✭✭
    edited 09/25/15



    We use a report to provide a condsolidated Project summary report to our CIO that is pulled weekly from 4 managers' project sheets.  Each IT manager has a host of projects he/she is managing.   The project entry may be just one line or if a large project, may have 4-8 subtasks under the main project row.  (We have a large project being mananaged in another SS that is updated via cell linking back to the manager's report.)


    Each manager then checks a checkbox on each project he/she wants pulled into the CIO report.  The report runs weekly and only selects those projects checked providing a summary of the fields on each project. 


    Hope that helps.



  • How are you managing to create an overdue task report?  Is smartsheet able to alert you when a milestone is about to be overdue?

  • In my sheets I have a column called "Status".  In that column, I use RYGG (Red-Yellow-Green-Gray) balls to reflect status.  Red status is where the task's end date is > today and the task is not complete.  See https://www.smartsheet.com/blog/support-tip-automate-RYG-balls on how to do this.


    In the Overdue Task Report, I simply filter for all tasks where status = red.

  • Jessica, it would depend on how you mark a task as overdue! Reports give you a lot of options so it is up to your process. For example, if a task is overdue because the Due Date is in the past and % Complete is not 100%, you can build a report that will show all your tasks that meets that criteria. 

This discussion has been closed.