Gantt Charts

Discussion List

• 
  Counting people with the same email domain in a multiselect assigned to cellAnswered Question

  Answered Martina Barnett 20 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 Functions207
  Martina Barnett
• 
  Planning Calendar conundrums

  Mary Vogt 40 views 14 comments 0 points Most recent by Mary Vogt 03/26/20Using Smartsheet
  First post 10/21/19,Last post 03/26/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 Smartsheet4014
  Mary Vogt
• 
  Missing columns on XML export of Gantt chartAnswered Question

  Answered Phil Schmitt 11 views 2 comments 0 points Most recent by Phil Schmitt 03/25/20Using Smartsheet
  First post 03/25/20,Last post 03/25/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 Smartsheet112
  Phil Schmitt
• 
  At Risk Formula Unparseable ErrorAccepted Answer

  Accepted Answer Kayla Johnstone 21 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 Smartsheet215
  Kayla Johnstone
• 
  Different font in Gannt header exported to PDF

  Mattias 30 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 Smartsheet303
  Mattias
• 
  count tasks per week numberAnswered Question

  Answered Assaf Elad 22 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 Functions221
  Assaf Elad
• 
  Gantt Bar Conditional Formatting not performing as expectedAnswered Question

  Answered michael anderson 25 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 Smartsheet251
  michael anderson
• 
  Non-working day shading in Gantt not consistentAccepted Answer

  Accepted Answer BJ Patnode 18 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 Smartsheet187
  BJ Patnode
• 
  Changing % complete using a formula in another cellAnswered Question

  Answered BJ Patnode 18 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 Functions182
  BJ Patnode
• 
  Notify an assignee that the predecessor has complete his task.

  Alexander Wirtz 127 views 4 comments 2 points Most recent by Brett Shapiro 02/27/20Formulas and Functions
  First post 03/26/19,Last post 02/27/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 Functions1274
  Alexander Wirtz
• 
  Percentage increasing by 100Answered Question

  Answered Gunn_Jack 22 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 Smartsheet229
  Gunn_Jack
• 
  How to import/merge 2 Smartsheet projects plan into 1?Answered Question

  Answered Francois Chagnon 26 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 Smartsheet263
  Francois Chagnon
• 
  Can I hide predecessor lines in a gantt chart?

  Project User 150 views 3 comments 0 points 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 Smartsheet1503
  Project User
• 
  Gantt View: Open to Today's Date Option

  a-mirvine68351 130 views 7 comments 0 points Most recent by Carol Westercamp 02/19/20Using Smartsheet
  First post 12/07/18,Last post 02/19/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 Smartsheet1307
  a-mirvine68351
• 
  How to link the health column to show an accurate status of at risk tasks.

  Becca Grunbaum 266 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 Functions26620
  Becca Grunbaum
• 
  Dashboard Report Widget: Columns Content and GANTT aren't in the same lineAccepted Answer

  Accepted Answer Gottfried Reichl Mueller 25 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 Smartsheet252
  Gottfried Reichl Mueller
• 
  2 or more projects sheet dependency

  Dynamics 279 views 5 comments 0 points Most recent by Nish Podakkudiyar 02/10/20Using Smartsheet
  First post 07/25/18,Last post 02/10/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 Smartsheet2795
  Dynamics
• 
  One Dependency for the start, another for the end?Answered Question

  Answered Ron Schaefer 24 views 1 comment 0 points Most recent by Paul Newcome 02/07/20Using Smartsheet
  First post 02/06/20,Last post 02/07/20
  Hi... I'm trying to set up a project that has a task (weekly update reports) that begins with one dependency (e.g., start of project), and ends with another dependency (e.g., on-site work). There are still some administrative tasks that c…
  Using Smartsheet241
  Ron Schaefer
• 
  Build Gantt Chart based on JIRA User Stories Story Points estimations

  NKH 104 views 3 comments 0 points Most recent by Andy Johnson 02/06/20Premium Apps and Integrations
  First post 11/16/18,Last post 02/06/20
  User story in Jira are estimated in Story Points (0.5, 1, 2, 3, 5, 8, 13, 21...) where each story point can be mapped to ideal days range such as a 0.5 story point = 1d, 1 story point: =2d 2 story points = 3d 3 story points = 5d ... …
  Premium Apps and Integrations1043
  NKH
• 
  Schedule VarianceAccepted Answer

  Accepted Answer James Pflueger 74 views 10 comments 0 points Most recent by Robert Gibbs 02/05/20Using Smartsheet
  First post 01/17/20,Last post 02/05/20
  How can I copy columns from one template and add them to a different template? I want to add the date variance column from the Project Gantt and budget template and add them to the Project plan template. I just want a way to baseline and t…
  Using Smartsheet7410
  James Pflueger
• 
  Color Coding In Progress Tasks within a Specific Time Period in Gantt ChartAnswered Question

  Answered Alyjon14 55 views 1 comment 0 points Most recent by Andrew Stewart 01/09/20Using Smartsheet
  First post 01/09/20,Last post 01/09/20
  Is there a way to color code tasks in a gantt chart that occur during a specific time period? For example, I would like all tasks that are in progress during the months of May, June and July to show as red. I see that I can set conditional…
  Using Smartsheet551
  Alyjon14
• 
  Viewing Deliverable for Multiple Projects by Month - NOT in a Gantt : )Answered Question

  Answered LLaCosta 38 views 3 comments 0 points Most recent by Andrée Starå 12/31/19Using Smartsheet
  First post 12/31/19,Last post 12/31/19
  So...any creative ideas for how to achieve something similar to the attached image IN Smartsheet? We want to visual represent high level deliverables across multiple projects for the entire year by Month, however, NOT in a Gantt view and w…
  Using Smartsheet383
  LLaCosta
• 
  Does a range of dates fall between another range of dates?

  samanthabooty 134 views 6 comments 0 points Most recent by Andrée Starå 12/29/19Formulas and Functions
  First post 01/28/19,Last post 12/29/19
  Hello, I have a need to be able to highlight if a range of dates falls between any other range of dates. I have a checkbox column which needs to be ticked if a range of dates conflicts with other range of dates. So for example, we might…
  Formulas and Functions1346
  samanthabooty
• 
  Baseline/Actual Schedule formula helpAccepted Answer

  Accepted Answer Nick Monroe 81 views 13 comments 0 points Most recent by Andrée Starå 12/20/19Formulas and Functions
  First post 12/19/19,Last post 12/20/19
  Hello all, I'm looking for some help with formulas in my schedule. With the schedule templet, I can insert the dates into the "start" and "finish" columns, the cells will auto populate. I would like to add two additiona…
  Formulas and Functions8113
  Nick Monroe
• 
  Changing Drop Down Value Based On Current Date?Answered Question

  Answered TRach 87 views 2 comments 0 points Most recent by Paul Newcome 12/17/19Formulas and Functions
  First post 12/05/19,Last post 12/17/19
  I am trying to change the drop down value on my Health column based on the current date. Is this possible? ie. If the start date value is in the past, the health column changes to "At Risk" which is one of the drop down choices.
  Formulas and Functions872
  TRach
• 
  Volunteer Allocation

  KDub618 50 views 2 comments 0 points Most recent by Paul Newcome 12/05/19Formulas and Functions
  First post 12/04/19,Last post 12/05/19
  Hi All,  I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…
  Formulas and Functions502
  KDub618
• 
  Forcing duration and start date to a specific value on Gantt

  ilene_healy68056 33 views 2 comments 0 points Most recent by ilene_healy68056 12/04/19Formulas and Functions
  First post 12/02/19,Last post 12/04/19
  Dear Community, Is it possible to set a formula so that the Start Date always equals the End Date and that the Duration is always '0'?  We are tracking key milestones and are only provided the End Date.  I'd like to reduce the manual entr…
  Formulas and Functions332
  ilene_healy68056
• 
  Rostering for Global Customer Support

  Chuck Perez 33 views 1 comment 0 points Most recent by Andrée Starå 12/04/19Formulas and Functions
  First post 12/03/19,Last post 12/04/19
  Hi,    I have been asked to create a roster that covers customer support across different time zones and shows who is available (human resources),  who is on leave, time, names of the support person and who is on call. Also, includes …
  Formulas and Functions331
  Chuck Perez
• 
  Creating a PMO functionality

  bukkymoh01 50 views 1 comment 0 points Most recent by Andrée Starå 11/26/19Formulas and Functions
  First post 11/26/19,Last post 11/26/19
  I have just been assigned the task of setting up the Project Management Office in my company. For now I need two things, firstly a project tracker for tracking and monitoring individual projects and then a master portfolio tracker where al…
  Formulas and Functions501
  bukkymoh01
• 
  gantt chart using time as a scale

  Closed Junho Kim 42 views 5 comments 0 points Most recent by kolfinna 11/25/19Archived 2016 Posts
  First post 02/08/16,Last post 11/25/19
  I would like to apply smart sheet to my workstation for daily manufacturing status board. Is there any chance for me to change gantt chart scale from date to time.  
  Archived 2016 Posts425
  Junho Kim