Master Task List By Resource

Bob Meynardie

We have multiple projects ongoing simultaneously.  In each project tasks are assigned to various team members by the managing partner.  Is there a way to have a task automatically roll into a master task list for the manager by resource (sort of a pivot table) or a consolidated task list for each resource team member to track for themselves?

SashaR

Try the reporting tool! A report will pull in rows from sheets based on criteria you specify. For example, you could pull in all the rows from multiple sheets that are assigned to a specific user. 

 

 

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

Fadi Mansour

Hi,

 

I have a similar question, but I also need to consolidate data.

 

Reports seem to only consolidate data, so multiple records could have similar information (lets way time sheet data with names and hours).

 

I need to consolidate the rows by summing the hours column for all the names.

 

I can't find anyway to do that, is there a way?