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.



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

WBS Numbering.

Task vs Summary Task (No children == task)


  • Tim Meeks
    Tim Meeks ✭✭✭✭✭✭

    Have you tried using the Reports feature?




    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.



This discussion has been closed.