-
Crosstab style reporting from Gantt data
Looking for some help on Crosstab style reporting from Shartsheet Gantt data. I have a Gantt project like the below ... How can I produce a report like this one I mocked up in an Excel Pivot table after cutting and pasting and "massaging" the Gantt data? ... Do I need the premium Pivot App (which we don't have) or is there…
-
Merged: Gantt View
This discussion has been merged.
-
Merged: More flexible Gantt and Timelines
This discussion has been merged.
-
Gantt Bar with milestone
Would be extremely helpful for high level reporting to be able to have a parent row which is showing the overall Gantt bar be able to display a child row as a milestone marker along that bar. Our project portfolio would benefit from being able to show the go-live milestone that is occurring during the project execution…
-
How to Show Cost / Budget on Gantt Chart
Hello - I used a simple project plan template and the Gantt chart is not showing anything. I would like for it to show at least the budget / cost, and if possible, I would also like it to show the Task. How can I do that? When I create a new sheet (without selecting a template, the Gantt chart shows the Task (or whatever…
-
Resource report gantt chart
Hello! I need to create a report to visualize resource utilization per project over time, similar to this: https://community.smartsheet.com/discussion/76598/how-do-you-track-parallel-projects-and-show-overlapping-resources Some important context: I do not have access to resource management or resource settings. All of my…
-
Allow editors and viewers to change gantt timescale when printing to PDF
Request: Allow users with editor or viewer access to change the timescale when printing a gantt view to a PDF, and for that setting to be persistent for that user. Background and our use case: I was not aware, but apparently editors cannot change timescale of the gantt when printing to PDF. They can change the display…
-
Gantt bar color in Report not matching color in Sheet
I have a Report that references timelines in a Sheet, and the colors do not match between the two. Why is this and how do I fix it? At first it looked like the report bar colors were importing the colors of children tasks, but even after updating those it won't adjust on the report.
-
How do you set up a project timeline to work around set meeting dates?
I am putting together a sheet / gantt chart for a project. My project needs to be approved by several committees as it progresses through various stages. These committees have fixed meeting dates that are scheduled out a year in advance and only happen once per month. Is there a way to program the currently scheduled…
-
Getting a group of predecessors to fill in sections
I have the same set of subtasks in my project that repeat over and over. I have predecessors set up for the flow and I want to copy and paste it down the sheet and have the associated rows update to the new numbers. Everything I try just copies and pastes the original set of row numbers. Updating every row manually is…
