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.

Need the ability to filter reports based on project status

Here is what I need.

 

I have about 50 projects within a workgroup that I am trying to manage.

 

I have a report of tasks that are due within the next 5 days.  Took some cluncky work to differentiate tasks vs summary tasks, but it was easy enough to do.

 

Next issue / challenge.

When a project stalls for some reason or another, I have no way to exclude that project without hacking a bunch of stuff up.

 

Recommendations.

Project (sheet) meta-data that is available as a filtering criteria. 

WBS Numbering.

Task vs Summary Task (No children == task)

Comments

  • Tim Meeks
    Tim Meeks ✭✭✭✭✭✭

    Have you tried using the Reports feature?

     

    http://help.smartsheet.com/customer/en/portal/articles/522214-creating-reports

     

    That would allow you to exclude those projects based on status.

     

    On the summary vs sub tasks, you could create a column checkbox to ID the summary row and just hide it? 

    Or is there some other criteria that defines the Summary tasks?

    We only assign a project # on the Summary Project row and not for the sub task/children so then we can run reports and pull only the tasks with a Project # is not blank.

     

    hope that helps.

     

    tim

This discussion has been closed.