Gantt Charts

Ask a Question

One person has multiple jobs on one dayQuestion

Question Ben Cutler 16 views 0 comments 0 points Started by Ben Cutler 05/26/20 Using Smartsheet

First post 05/26/20,Last post 05/26/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 Smartsheet160
Ben Cutler
Gantt Chart status bar doesn't appear to reflect progress

Richard Heath 177 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 Smartsheet1772
Richard Heath
Date Range Printing

simon78306 58 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 Smartsheet582
simon78306
Elapsed time - 24hr workday - Display bug?

David Hayes 27 views 3 comments 1 point Most recent by Chris Atkinson 05/21/20Using Smartsheet

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…
Using Smartsheet273
David Hayes
Notify an assignee that the predecessor has complete his task.

Alexander Wirtz 213 views 5 comments 2 points Most recent by jwilson10533 05/07/20Formulas and Functions

First post 03/26/19,Last post 05/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 Functions2135
Alexander Wirtz
2 pet peeves - Printing and Filters for columnsQuestion

Answered - Pending Review Jonah B @ Job Shop 18 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 Smartsheet181
Jonah B @ Job Shop
Status corresponding to % CompleteQuestion

Answered - Pending Review Brett Macias 15 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 Functions151
Brett Macias
2 or more projects sheet dependency

Dynamics 457 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 Smartsheet4576
Dynamics
Highlighting Gantt Chart Date ColumnsQuestion

Answered - Pending Review Jerry Tice 2 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 Smartsheet21
Jerry Tice
Report Builder: Gannt Chart Predecessors Not Working

ARCHIPEEP 155 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 Smartsheet1558
ARCHIPEEP
Gantt View: Open to Today's Date Option

a-mirvine68351 210 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 Smartsheet2109
a-mirvine68351
Planning Calendar conundrums

Mary Vogt 55 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 Smartsheet5522
Mary Vogt
Lock Gantt view date on Dashboard from a reportQuestion

Answered - Pending Review Rick Benton 14 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 Smartsheet141
Rick Benton
report: take over colors in grid view of a projectQuestion

Answered - Pending Review Koen Placke 3 views 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 Smartsheet31
Koen Placke
how do I add a calendar view in a Dashboard?

Jef Forward 500 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 Smartsheet5003
Jef Forward
Plotting cost over time

Mike Liggett 127 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 Functions1277
Mike Liggett
Contact not displaying name on Assigned To field

LW 288 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 Smartsheet28814
LW
Missing columns on XML export of Gantt chartQuestion

Answered - Pending Review Phil Schmitt 23 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 Smartsheet233
Phil Schmitt
Counting people with the same email domain in a multiselect assigned to cellQuestion

Answered - Pending Review Martina Barnett 36 views 7 comments 0 points Most recent by Paul Newcome 03/26/20Formulas and Functions

First post 03/25/20,Last post 03/26/20
Hi there I have a multiselect Assigned To column linked to a contact list. So the contacts are displayed with their full names. Email addresses are shown in the hover over menu for each contact as per usual. I want to count how many of t…
Formulas and Functions367
Martina Barnett
At Risk Formula Unparseable ErrorAccepted Answer

Accepted Answer Kayla Johnstone 23 views 5 comments 0 points Most recent by Paul Newcome 03/20/20Using Smartsheet

First post 03/19/20,Last post 03/20/20
I am trying to build a nested at risk formula based on the following triggers. -End date is today and Status is not complete it will trigger -There is not enough time between today and the end date for the duration period left. So, if dura…
Using Smartsheet235
Kayla Johnstone
Different font in Gannt header exported to PDF

Mattias 33 views 3 comments 0 points Most recent by Andrée Starå 03/12/20Using Smartsheet

First post 12/02/19,Last post 03/12/20
Anyone else seen this? Not sure if it has been like this since the start or if its a new thing... Is there a setting to correct this? (Image)
Using Smartsheet333
Mattias
count tasks per week numberQuestion

Answered - Pending Review Assaf Elad 53 views 1 comment 0 points Most recent by Paul Newcome 03/10/20Formulas and Functions

First post 03/10/20,Last post 03/10/20
Hi community, I'm trying to count the tasks in my gannt per each week in a separate grid. Then i'll make a graph representing work overloads throughout the year. Here is my formula that calculate 0 every time (at least not an error) : =COU…
Formulas and Functions531
Assaf Elad
Gantt Bar Conditional Formatting not performing as expectedQuestion

Answered - Pending Review michael anderson 43 views 1 comment 0 points Most recent by Genevieve P 03/09/20Using Smartsheet

First post 03/04/20,Last post 03/09/20
Hello Community, I am attempting to use conditional formatting to change the color of my Gantt bars; however, the conditional format is not being applied to the Gantt bars. Here is my conditional formatting You can see below that I specify…
Using Smartsheet431
michael anderson
Non-working day shading in Gantt not consistentAccepted Answer

Accepted Answer BJ Patnode 23 views 7 comments 0 points Most recent by BJ Patnode 03/04/20Using Smartsheet

First post 03/02/20,Last post 03/04/20
When I select Gantt view some of my child tasks have work day and non-work day shading. Non-workdays are light grey and work days are White. This occurs randomly on the sheet. Several child rows have no formatting and some have the gre…
Using Smartsheet237
BJ Patnode
Changing % complete using a formula in another cellQuestion

Answered - Pending Review BJ Patnode 25 views 2 comments 0 points Most recent by BJ Patnode 03/02/20Formulas and Functions

First post 02/28/20,Last post 03/02/20
I know you cannot use a formula in a "% Complete" field. Is there a way to update "% Complete" from a formula in another column (something like a "helper" column)? I have a "Task Status" column wit…
Formulas and Functions252
BJ Patnode
Percentage increasing by 100Question

Answered - Pending Review Gunn_Jack 23 views 9 comments 0 points Most recent by Paul Newcome 02/26/20Using Smartsheet

First post 02/26/20,Last post 02/26/20
Hi all, I have an issue where, when inputting a percentage into the %Complete column which accompanies the Gantt, it multiplies this percentage by 100! I.e. it turns 1 into 100% and 100 into 10,000% - screwing with the sheet. The strange t…
Using Smartsheet239
Gunn_Jack
How to import/merge 2 Smartsheet projects plan into 1?Question

Answered - Pending Review Francois Chagnon 47 views 3 comments 0 points Most recent by Andrée Starå 02/26/20Using Smartsheet

First post 02/20/20,Last post 02/26/20
I need to import an existing project plan (call it A) into an already project plan (call it B). A is under a different corporate account than B. I have access to both. I need to merge the 2 project plans into 1. The question probably has b…
Using Smartsheet473
Francois Chagnon
Can I hide predecessor lines in a gantt chart?

Project User 260 views 3 comments 1 point Most recent by Anthony Gonsalves 02/25/20Using Smartsheet

First post 03/07/19,Last post 02/25/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 Smartsheet2603
Project User
How to link the health column to show an accurate status of at risk tasks.

Becca Grunbaum 453 views 20 comments 0 points Most recent by Genevieve P 02/17/20Formulas and Functions

First post 08/12/19,Last post 02/17/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 Functions45320
Becca Grunbaum
Dashboard Report Widget: Columns Content and GANTT aren't in the same lineAccepted Answer

Accepted Answer Gottfried Reichl Mueller 36 views 2 comments 0 points Most recent by Genevieve P 02/12/20Using Smartsheet

First post 02/11/20,Last post 02/12/20
Created a report and added the report via widget to the dashboard. Realized, that the lines are not matching....Content line height is obviously different to the GANTT line height. The report itself looks good and correct - the change is o…
Using Smartsheet362
Gottfried Reichl Mueller

Ask a Question

Gantt Charts

Gantt Charts

Discussion List