Sign in to join the conversation:
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?
Hi,
Yes, either with a report or thru cell linking to another sheet.
Would that work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
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.
Hi, "Fields marked with an asterisk (*) are required." is the very first line in the body of every form I create. I don't remember seeing it before (unless you missed filling out a required field; then you would see the message). Is there a way to turn it off or change it? None of my forms are in English so the message is…
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
I have a dynamic view setup for a dashboard that has NO restrictions And on the Sharing tab, I have a Group that I created as the additional share access to the view But the individuals in the Group still cannot see the data from the dashboard. Am I missing something? Because when I share the view to them individually…
