Gantt Charts

Discussion List

  • Gantt View Timeline color coded by stages
    In Using Smartsheet
    I am looking to develop a Gantt view that shows multiple colors on a single bar, based on the calendar, and corresponding stage of the project at that time. For example: Project XYZ, single timeline: red during planning stage (Oct 7-14), g…
    21 1
    Accepted Answer 21 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Dates start flashing after updating another task's predecessors
    In Using Smartsheet
    I have a project plan that I am now updating to establish dependencies. Everything was going fine until I updated one task's predecessors and a completely separate row's dates (and associated span in the gantt chart) started flashing. I'm …
    1732 11
    1.7K views 11 comments Most recent by Trevor Collins Using Smartsheet
  • Gantt charts and Dashboards
    In Using Smartsheet
    Hi.  new here to the forum; recently created a Smartsheet Gantt chart and subsequently integrated it into a Smartsheet Dashboard. Looks great except --- I seem to have lost my indentation of my subtasks under a parent task, and that makes…
    881 4
    881 views 4 comments Most recent by @Marino Anderson Using Smartsheet
  • Volunteer Allocation
    In Formulas and Functions
    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…
    118 3
    118 views 3 comments Most recent by Brianne Laird Formulas and Functions
  • Gannt chart start date does not match the date column
    In Using Smartsheet
    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, but the …
    150 3
    Accepted Answer 150 views 3 comments Most recent by itsnotbroken Using Smartsheet
  • Formula to calculate date
    In Formulas and Functions
    Hello, I am trying to work backwards but I just don't get it. My event date is my constraint, I want some tasks to be completed x days prior to the event and Smartsheet to calculate the start date of the tasks automatically. For example, …
    15 3
    Accepted Answer 15 views 3 comments Most recent by Berenice Vanderley Formulas and Functions
  • Formula under Duration in a Gant chart
    In Formulas and Functions
    Hi there, I'm new to smartsheet I want to switch from MS Project to smartsheet to set up the planning schedule. I know we can assign multiple of people to a task but at the planning/biding level, I just want to juggle with the number of re…
    200 2
    200 views 2 comments Most recent by Caitlin Smith Formulas and Functions
  • Gantt chart that overlays multiple projects
    In Using Smartsheet
    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 …
    551 2
    551 views 2 comments Most recent by James Robitaille Using Smartsheet
  • Overall Total % completed
    In Formulas and Functions
    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…
    57 7
    Accepted Answer 57 views 7 comments Most recent by Paul Newcome Formulas and Functions
  • Gantt - Progress Ahead or Behind Schedule?
    In Formulas and Functions
    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…
    753 5
    753 views 5 comments Most recent by Paul Newcome Formulas and Functions