Gantt Charts

Ask a Question

Gannt chart start date does not match the date columnQuestion

Answered - Pending Review itsnotbroken 22 views 1 comment 0 points Most recent by Genevieve P 08/12/20Using Smartsheet

First post 08/11/20,Last post 08/12/20
(Image) Hi, Pretty long project, spanning a bit over a year. I'm about halfway through it & the Gannt Dates started getting weird. In the image, Look at "Floors", predecessor 232. The scheduled start date column says 8/13, …
Using Smartsheet221
itsnotbroken
Gantt chart that overlays multiple projects

DanielleElise 213 views 2 comments 0 points Most recent by James Robitaille 08/02/20Using Smartsheet

First post 02/06/19,Last post 08/02/20
We are trying to see if there is a way to view a Gantt chart that overlays projects that are in multiple sheets so that we can make sure our department is not spreading itself too thin/which projects have overlapping timelines. Is there a …
Using Smartsheet2132
DanielleElise
Version Control of Project Plans/Sheets?

Ivana 458 views 4 comments 0 points Most recent by Riyaz M 08/02/20Using Smartsheet

First post 11/04/19,Last post 08/02/20
Hello, I am wondering if there is a way in Smartsheet to version control the sheets. Basically, we are using each sheet as an individual project plan. However, as projects progress, the plan will (usually) slip and/or have to be updated, s…
Using Smartsheet4584
Ivana
Overall Total % completedAccepted Answer

Accepted Answer Grant Graves 21 views 7 comments 0 points Most recent by Paul Newcome 07/20/20Formulas and Functions

First post 06/22/20,Last post 07/20/20
Sorry If this is a repeat but the first post seemed to have disappeared. My Goal is to have the Top row #1 Where that checkbox is to say what the total of completed of all the subtaks below. For example the Level 4 is showing 100% complet…
Formulas and Functions217
Grant Graves
Gantt - Progress Ahead or Behind Schedule?

Chris_Bick 285 views 5 comments 0 points Most recent by Paul Newcome 07/17/20Formulas and Functions

First post 04/10/19,Last post 07/17/20
Hi All I'm keen to look into options to report on project progress against schedule. Generally we set a project programme, then progressively update %Complete against lines and the project progresses. The progress bar works well as visu…
Formulas and Functions2855
Chris_Bick
Complete Through Progress BarQuestion

Answered - Pending Review Nick Casiday 42 views 1 comment 3 points Most recent by Genevieve P 07/16/20Formulas and Functions

First post 07/14/20,Last post 07/16/20
My organization is moving from MS Project to Smartsheet and there is a functionality on the progress bar of the gantt chart in MS Project that I would like to see if Smartsheet can do. The Update Progress bar that shades % Complete in MS P…
Formulas and Functions421
Nick Casiday
Returning Start and End DatesQuestion

Answered - Pending Review Griffin Fujii 21 views 5 comments 0 points Most recent by Paul Newcome 07/15/20Formulas and Functions

First post 07/15/20,Last post 07/15/20
Hi All, (Image) I am trying to get the MIN or start date of a range that only grabs from the row with the same phase. Keep in mind these Start and End dates in the project plan below have dependencies enabled. (Image) I would like to retu…
Formulas and Functions215
Griffin Fujii
Automatic Predecessor Adjustment

ryan.diamond55371 105 views 6 comments 0 points Most recent by Jon Wilbur Tan 07/15/20Formulas and Functions

First post 01/02/19,Last post 07/15/20
Hey All! I have a question about how to have predecessors or just tasks in a schedule to automatically update when they are moved in the schedule. I am trying to create a production schedule for our Sheet Metal shop and it is created with…
Formulas and Functions1056
ryan.diamond55371
Notify an assignee that the predecessor has complete his task.

Alexander Wirtz 309 views 6 comments 3 points Most recent by Tori Isbell 07/07/20Formulas and Functions

First post 03/26/19,Last post 07/07/20
I want to use smartsheet as an international project management tool. One thing is driving me creasy. I want to send out a notification to an assignee if the predecessor task is completed. Please find attached a screenshot of my scenario.…
Formulas and Functions3096
Alexander Wirtz
Resource Management ToolQuestion

Answered - Pending Review SteCoxy 61 views 6 comments 0 points Most recent by SteCoxy 06/22/20Using Smartsheet

First post 06/08/20,Last post 06/22/20
I'm looking at how I can migrate project plans (Omniplan) into Smartsheet to then use the resource management element to see people's capacity and adjust the schedule to smooth delivery. Has anyone done something similar or have any learni…
Using Smartsheet616
SteCoxy
Need help with 'If , Then' function to subtract Duration ValuesAccepted Answer

Accepted Answer J Fitzpatrick 32 views 3 comments 0 points Most recent by Paul Newcome 06/15/20Formulas and Functions

First post 06/10/20,Last post 06/15/20
I'm setting up a Construction Schedule with Variance calculations as the 'Near Term' baseline solution that's been quoted as coming for a few years now has not materialized yet. Unfortunately after searching the forums I'm not seeing synt…
Formulas and Functions323
J Fitzpatrick
How to link the health column to show an accurate status of at risk tasks.

Becca Grunbaum 680 views 22 comments 0 points Most recent by Genevieve P 06/15/20Formulas and Functions

First post 08/12/19,Last post 06/15/20
Hi All, I am looking to find a way that I can link (create a formula) so the health column shows a traffic light system for the status of the task. I want to aim for this to detect the percentage of completion of a task in relation to …
Formulas and Functions68022
Becca Grunbaum
Can I hide predecessor lines in a gantt chart?

Project User 430 views 4 comments 2 points Most recent by Daniel Need 06/11/20Using Smartsheet

First post 03/07/19,Last post 06/11/20
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…
Using Smartsheet4304
Project User
One person has multiple jobs on one dayQuestion

Answered - Pending Review Ben Cutler 21 views 1 comment 0 points Most recent by Genevieve P 05/28/20Using Smartsheet

First post 05/26/20,Last post 05/28/20
Hi, I'm looking to adjust my sheet based on one person having multiple jobs in one day. What I'd like to do it have it be that each person has only one job per day. Ideally, SS would be able to look at all other jobs this person is assigne…
Using Smartsheet211
Ben Cutler
Gantt Chart status bar doesn't appear to reflect progress

Richard Heath 256 views 2 comments 0 points Most recent by Nick Casiday 05/26/20Using Smartsheet

First post 10/23/19,Last post 05/26/20
Our PM's are experiencing a few issues with the Gantt Chart, and I hoping someone can help. In some instances, per the attached, the overall status suggests that the program is ahead of schedule. This is despite Sub-child 2a being on targ…
Using Smartsheet2562
Richard Heath
Date Range Printing

simon78306 81 views 2 comments 1 point Most recent by KimW 05/22/20Using Smartsheet

First post 02/12/19,Last post 05/22/20
Hi, I am having trouble printing a specific date range in gantt view. I've selected the dates, tried printing, but it shows the full spread and never reduces to the specified date range. HELP! Thanks, Simon
Using Smartsheet812
simon78306
Elapsed time - 24hr workday - Display bug?

David Hayes 32 views 3 comments 1 point Most recent by Chris Atkinson 05/21/20Formulas and Functions

First post 06/29/18,Last post 05/21/20
See the attached pic. * The sheet is set for 24hr workdays. Mon-Fri. * There are 2 tasks. one with duration 7d and one with duration e7d. * The e7d task does not display 7 days of working. The gantt chart bar does not show sun…
Formulas and Functions323
David Hayes
2 pet peeves - Printing and Filters for columnsQuestion

Answered - Pending Review Jonah B @ Job Shop 32 views 1 comment 1 point Most recent by Andrée Starå 05/05/20Using Smartsheet

First post 05/05/20,Last post 05/05/20
Not really a question. More of constructive criticism/asking for better developed features. I use Smartsheet as a scheduling tool at our company, We use master project sheets and a series of project reports and company reports. We generall…
Using Smartsheet321
Jonah B @ Job Shop
Status corresponding to % CompleteQuestion

Answered - Pending Review Brett Macias 21 views 1 comment 0 points Most recent by Paul Newcome 05/04/20Formulas and Functions

First post 05/02/20,Last post 05/04/20
I would like to figure a way for the Status Column to auto fill depending on what the % Complete says. For instance: 0% = Not Started 1-99% In Progress 100% - Complete Conditional Formatting is not the way to go and I can't figure out the …
Formulas and Functions211
Brett Macias
2 or more projects sheet dependency

Dynamics 659 views 6 comments 0 points Most recent by Sandra Guzman 05/04/20Using Smartsheet

First post 07/25/18,Last post 05/04/20
HI, I am using Smartsheet and I am involve in 3 projects and all are main and lead roles. I made 3 separate sheets for each project but I realize each projects affect the other projects and then sometimes the predecessor is in another sh…
Using Smartsheet6596
Dynamics
Highlighting Gantt Chart Date ColumnsQuestion

Answered - Pending Review Jerry Tice 11 views 1 comment 0 points Most recent by Andrée Starå 05/01/20Using Smartsheet

First post 04/30/20,Last post 05/01/20
I have several projects that were suspended due to Covid issues but are starting to open back up. I have to push out everything due to this suspension and I would like to highlight (or just delete/hide) those date columns during the suspen…
Using Smartsheet111
Jerry Tice
Report Builder: Gannt Chart Predecessors Not Working

ARCHIPEEP 183 views 8 comments 0 points Most recent by chris.stetler83201 04/30/20Using Smartsheet

First post 03/09/18,Last post 04/30/20
I'm trying to run a single report of my 5 project schedules so I can quickly see aligning milestones and deliverables. However, when I run the report, all of the predecessors become unconnected and the columns report 1 predecessor. This is…
Using Smartsheet1838
ARCHIPEEP
Gantt View: Open to Today's Date Option

a-mirvine68351 289 views 9 comments 0 points Most recent by Paul LeBar 04/29/20Using Smartsheet

First post 12/07/18,Last post 04/29/20
I am a fairly new SS user and am owner/admin for a large project/Gantt sheet that is shared internally with other Project Managers, who are also fairly new to SS. They have edit permission, but are not admins. I have set the project option…
Using Smartsheet2899
a-mirvine68351
Planning Calendar conundrums

Mary Vogt 62 views 22 comments 0 points Most recent by mitchell.beness113091 04/28/20Using Smartsheet

First post 10/21/19,Last post 04/28/20
Hi, Community! I am wondering if anyone else is using SmartSheet for an institutional planning calendar. I chose a template of project with gantt. Most of the tasks on the calendar, however, are annual, bi-annual, semi-annual, etc. I am tr…
Using Smartsheet6222
Mary Vogt
Lock Gantt view date on Dashboard from a reportQuestion

Answered - Pending Review Rick Benton 22 views 1 comment 0 points Most recent by Genevieve P 04/27/20Using Smartsheet

First post 04/24/20,Last post 04/27/20
Hello, I am pulling data into a report and displaying on my dashboard. The gantt view always starts on March 15th. Executives viewing the report want to have it start on today's date. The both the source sheet and report's gantt view is…
Using Smartsheet221
Rick Benton
report: take over colors in grid view of a projectQuestion

Answered - Pending Review Koen Placke 1 view 1 comment 0 points Most recent by Andrée Starå 04/23/20Using Smartsheet

First post 04/23/20,Last post 04/23/20
Hello, her's my build. I have a project file (file 1) with all details of different project but always with the same structure with different colors. Out of that I created a second PM file (file 2) with links to that main Project file (fi…
Using Smartsheet11
Koen Placke
how do I add a calendar view in a Dashboard?

Jef Forward 738 views 3 comments 0 points Most recent by Harvey Mon 04/18/20Using Smartsheet

First post 05/01/19,Last post 04/18/20
Hello - I have searched the community and have found a "work-around", but it doesn't work. I am trying to show a calendar view of a clients project on a client dashboard. I only want them to be able to see it. I don't want them…
Using Smartsheet7383
Jef Forward
Plotting cost over time

Mike Liggett 197 views 7 comments 0 points Most recent by Andrée Starå 04/16/20Formulas and Functions

First post 06/14/18,Last post 04/16/20
Hi- I am trying to either graphically or with subtotals display cost over time as aggregated preferably by month, but also want to consider by week. I am easily able to plot cost for items that begin or end in a calendar month, but not…
Formulas and Functions1977
Mike Liggett
Contact not displaying name on Assigned To field

LW 449 views 14 comments 0 points Most recent by Kaela Vela 04/09/20Using Smartsheet

First post 04/30/19,Last post 04/09/20
When I try to add one particular contact that I added to my contacts list to the Assigned To field on a Gantt chart, it won't display the Name... just the person's full email address. This is only happening for this one contact - the rest …
Using Smartsheet44914
LW
Missing columns on XML export of Gantt chartQuestion

Answered - Pending Review Phil Schmitt 31 views 3 comments 0 points Most recent by Andrée Starå 03/31/20Using Smartsheet

First post 03/25/20,Last post 03/31/20
I have several columns I need to export with my Gantt chart but only the standard Gantt columns seem to export. Every new column I added to the Gantt chart does not export. I even re-loaded the XML back into Smartsheet and the data is m…
Using Smartsheet313
Phil Schmitt

Ask a Question

Gantt Charts

Gantt Charts

Discussion List