Gantt Charts

Discussion List

  • Elapsed time - 24hr workday - Display bug?
    In Formulas and Functions
    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…
    76 3
    76 views 3 comments Most recent by Chris Atkinson Formulas and Functions
  • 2 pet peeves - Printing and Filters for columns
    In Using Smartsheet
    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…
    Answered - Pending Review
    107 1
    Answered - Pending Review 107 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Status corresponding to % Complete
    In Formulas and Functions
    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 …
    Answered - Pending Review
    21 1
    Answered - Pending Review 21 views 1 comment Most recent by Paul Newcome Formulas and Functions
  • Highlighting Gantt Chart Date Columns
    In Using Smartsheet
    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…
    Answered - Pending Review
    24 1
    Answered - Pending Review 24 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Report Builder: Gannt Chart Predecessors Not Working
    In Using Smartsheet
    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…
    327 8
    327 views 8 comments Most recent by chris.stetler83201 Using Smartsheet
  • Planning Calendar conundrums
    In Using Smartsheet
    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…
    85 22
    85 views 22 comments Most recent by mitchell.beness113091 Using Smartsheet
  • Lock Gantt view date on Dashboard from a report
    In Using Smartsheet
    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…
    Answered - Pending Review
    42 1
    Answered - Pending Review 42 views 1 comment Most recent by Genevieve P. Using Smartsheet
  • report: take over colors in grid view of a project
    In Using Smartsheet
    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…
    Answered - Pending Review
    2 1
    Answered - Pending Review 2 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • how do I add a calendar view in a Dashboard?
    In Using Smartsheet
    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…
    1906 3
    1.9K views 3 comments Most recent by Harvey Mon Using Smartsheet
  • Plotting cost over time
    In Formulas and Functions
    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…
    458 7
    458 views 7 comments Most recent by Andrée Starå Formulas and Functions