-
Why are these columns blue in GanttView and how to do I remove it?
Hi everyone! I am running into an issue in my sheet, report, and dashboard. In the main sheet, I have several line items that associate with a gantt chart for project management. Three of them are highlighted / shaded in blue with no conditional formatting that correlates to that setting. Anyone know why this is occurring?…
-
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…
-
Can I hide predecessor lines in a gantt chart?
I have a complicated project with tons of predecessors. The predecessor lines connecting tasks in the gantt view are so numerous that is makes the gantt visually hard to use. Is there are way to hide or turn off not the predecessors, but the predecessor lines? Thanks!
-
Merged: Gantt View: show milestones in the parent summary when collapsed
This discussion has been merged.
-
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…
-
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…
-
Gantt colors and Dashboards - is there an easier way for my issue?
The issue I'm having is that I'm creating a milestone dashboard with gantt view, but need to be able to change the colors of the gantt chart, which can only be done in the grid sheet. Smartsheets does not allow for changing the gantt colors of lines that are considered headers, subheaders, etc. Only task lines. So now I'm…