Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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?
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
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?
