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.
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…
Hello team! Hope you all are having a wonderful holiday season. I am trying to set up an automation that will send an email reminder one time when Next Update Date = 60 days, then another automation at 30d, etc. The key is I only want it to send the reminder one time when Next Update threshold is reached. Is this possible?…
Has anyone found a workaround for sharing Smartsheet reports externally without giving access to internal data? I currently have to download the data and transfer it onto excel to create a pivot table for our client and I want to find an easier way to do so. I also already create a dashboard for our client, but I wanted…
