We create a detailed Gantt chart for each project we are working internally. I'd like to roll up that data to a higher view where I can see where we stand with each project on a single Gantt chart. Is this possible?
Yes, either with a report or thru cell linking to another sheet.
Would that work?
Have a fantastic week!
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
I tried to do this as well, but never landed on a super clean outcome.
The struggle is that any "New" project that you create is not automatically included in your preexisting "Roll-up" view. You would have to manually add any new projects to the cell linking each time a new one was created.
I'm currently working on a possible solution by using the "Reports" tool, but it still requires a small bit of manual hand holding. I am putting all of my active projects into a single directory in Smartsheet. Then each time I want to roll all of the active projects into a single report, I have to manually update the "Where?" selection by unselecting then reselecting the entire folder where the active projects are stored. This picks up any newly added projects. Then the results can be displayed in the report, which I have set to show as a Gantt View.
If this sounds like a feasible solution for you, I can attempt to provide more specific details. The main trick is to organize whatever projects you want to be included into a single directory in Smartsheet. Then you can move them out of that folder (but not a subdirectory of the same folder) once you no longer want them to be included.
I've been trying to do a simple check of whether or not the entry from the form has a returned value that is either yes or no and it checks 3 cell locations to see if any returned yes. The 3 columns are Dropdown lists for Yes/No and the Status is a Text/Number, is that the issues? If not how do i fix that?
I'm wondering if there is a way to lock rows 1-12 out of the sorting and filtering of a sheet. I might have take out that part of the from otherwise I dont like how the built in dashboard moves when a sort or filter is applied?
Hello, I apologize if this has already been answered, I did search before asking. I recently downloaded a template and it had the google slides displayed in presentation mode. I cannot figure out how to do this as when I embed, it's just the entire google page where you can edit and see the menu bar. How do I embed the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.