Master Task List By Resource

Bob Meynardie · 06/03/15

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 · 06/04/15

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 · 01/12/17

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?

Welcome to the Smartsheet Forum Archives

Master Task List By Resource

Comments

Categories