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:
Hello,
Is there anyway to have a project task list that is updated from multiple project task list sheet? We are looking to have a master roll up of the Project Milestones without including all the tasks on 1 task list.
Thank you
Would a report do what you're after? You could include all your project sheets and set criteria in the report to specify only rows with a 0 duration.
This is by far the simplest way to achieve this.
https://community.smartsheet.com/discussion/what-best-practices-are-there-roll-master-sheet
https://community.smartsheet.com/discussion/master-roll-sheet-and-reports
https://community.smartsheet.com/discussion/recommended-master-project-document
https://community.smartsheet.com/discussion/sheet-roll
https://community.smartsheet.com/discussion/multiple-project-task-list-roll
https://community.smartsheet.com/discussion/assistance-rolling-data-master-sheet
https://community.smartsheet.com/discussion/how-start-building-project-roll-110-dropdown-names-pick-also
https://community.smartsheet.com/discussion/what-best-way-consolidate-data-multiple-sheets
https://community.smartsheet.com/discussion/creating-master-sheet-composed-dependent-dept-sheets-sheet-linking-sub-sheets
You aren't the only one with this problem. That was with a single search on google. In fact I asked the same question yesterday hoping someone had a new response. The two answers right now are cell linking which takes a huge amount of time and is extremely inefficient, and building a report which takes away the ability to perform any calculations on the data you are pulling from different sheets.
There is a 3rd option, but it's relatively expensive (we're talking 10s of thousands):
https://www.smartsheet.com/product/control-center
https://www.smartsheet.com/videos/smartsheet-control-center-it-project-management
Hi all, Hopefully this is a simple solution that I'm just missing, but if I have a report view of a main sheet, is there a way to click on a particular row in the report and have it link to the full details available in the parent sheet? I want to be able to provide folks a simple view of everything, but reports fail for…
Hi Community, We encountered an unexpected issue with a Dynamic View today. An admin who had previously been added to the Dynamic View was found to be missing from the Admin list. We are confident that the admin was not manually removed or edited by our team. We noticed the issue at approximately 9:30 AM on Monday (UTC+8),…
Hi, This morning (UTC+8) we can not edit the data shuttle. When I go into the edit page of data shuttle it says I need to ask for access approval to continue. But I am the manager of the data shuttle. And from the sharing setting page, I can confirm that I am still in the manager list. Is this an internal server problem?…