-
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…
-
Lock A Specific View (so users can't switch to another view)
We'd like the ability to restrict a view in a report or in a sheet so that a user can ONLY view a sheet or report in a specific view (like Card View, Grid View, etc.) Example: Our team discovered Card View is the safest way to allow multiple users to have Edit access to a sheet or report while lowering the chances of them…
-
adjusting the way baseline columns generate
Hi, I would like to make it so if I turn on baselines, I can use currently existing columns for dates and variance, rather then having to generate new ones. The reason for this is so I can use those columns in pre-made reports that are consistent across all projects built from a template, rather than having to manually…
-
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…
-
Gantt Chart Alignment
I created a smartsheet using the Gantt chart template. For some reason the Gantt chart lines are slightly larger than the task lines. So when you're looking at a task and look right to see the gantt chart, it does not align with the proper task (Screenshot attached). This seems like Gantt 101 - The line has to match up…
-
Update Project Status Automatically from Gantt Chart
I am currently using Smartsheet to create a Gantt chart for each project as well as a table to keep track of project status'. I would really like to have the Gantt chart automatically update the project status so I don't have to do everything twice.
-
Color of Progress Bar in Report in Gantt View
I am running a report and when I do, the color of the progress bar in gantt view changes colors. One the individual sheet the bars and green, but they change to blue, orange, red, yellow, etc in the report. I cannot find any correlation to what colors they are changed to. Has anyone else seen/experienced this?
-
Milestones showing at start of next day vs. end of day
I noticed a change in the milestone logic today, and I'm wondering if there's a way to revert back to how it was before or if there is something I'm missing. Before today, a milestone (a task with 0 duration) would show that milestone occurs at the END of the day of the predecessor task. But now, it has the milestone task…
-
Gantt scaling problem when export SmartSheet Gantt to PDF
Hi, I have a project SmartSheet in gantt view. On screen, I adjust the Gantt to quarter scale (i.e. 1st level in Q1, Q2 and Q3 with 2nd level in Apr, May and Jun). When I export the Sheet to PDF, the output PDF is scaled to month (i.e. 1st level in Apr, May and Jun with 2nd level in week). In this particular Sheet, I have…