Gantt Charts

Discussion List

  • In a Gantt with many rows, how to color a date range that spans all rows in a column?
    In Using Smartsheet
    In other words, I have a developed Gantt with many rows. There's an event that I'd like to track in the Gantt that occurs over the course of several weeks. I would like to highlight that date range but not just have it on one row, I want i…
    Answered - Pending Review
    15 3
    Answered - Pending Review 15 views 3 comments Most recent by Scott Rapoport Using Smartsheet
  • Conditional search and return
    In Formulas and Functions
    My "Start" column has dates for each row; the "Primary" column has ~20 unique values and the sheet has ~80 rows with no parent rows; the "Task" column is mostly unique in each row instance. I am trying to ret…
    13 3
    Accepted Answer 13 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Gantt View Background Cell View
    In Using Smartsheet
    In a new sheet I'm creating the Gantt view background cell color (not the task bar) is dark blue making it very difficult to read anything. I can't see any option to change this. Can anyone point me in the right direction? Thanks
    Answered - Pending Review
    14 2
    Answered - Pending Review 14 views 2 comments Most recent by Damon Krause Using Smartsheet
  • Formula for RYG for Project Schedule Status
    In Formulas and Functions
    We were able to create a formula for Green and Red status but have not figured out how we can automatically set the project status to YELLOW. Normally if an activity(s) are slipping that affects the critical path the project should be in …
    Answered - Pending Review
    21 1
    Answered - Pending Review 21 views 1 comment Most recent by Malaina Hudson Formulas and Functions
  • Rolling up multiple projects onto a dashboard
    In Using Smartsheet
    Is there a way to roll up the critical pathways and key milestones for multiple projects / smartsheets into one dashboard?
    35 3
    Accepted Answer 35 views 3 comments Most recent by Bassam.M Khalil Using Smartsheet
  • Smartsheet - Procore & Cyberco Sync
    In Premium Apps and Integrations
    We just started creating schedules in Smartsheet and are trying to sync them to Procore via Cyberco and running into issues. Cyberco's site is vague with little in ways support material. Would love to hear some experiences / input on this …
    Answered - Pending Review
    11 1
    Answered - Pending Review 11 views 1 comment Most recent by Chris Mondeau Premium Apps and Integrations
  • Gantt Chart - Percentage Complete
    In Formulas and Functions
    Hi, I'm new in Smartsheet coming from the MS Project world. I'm trying to include the % of task completion in a gantt chart. I'm filling in the % complete column but nothing appears on the gannt chart (contrary to what is described in http…
    Answered - Pending Review
    24 5
    Answered - Pending Review 24 views 5 comments Most recent by Andrée Starå Formulas and Functions
  • Gantt View: Open to Today's Date Option
    In Using Smartsheet
    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…
    546 10
    546 views 10 comments Most recent by Thomas Rygh Using Smartsheet
  • Report builder - Collapse and Expand Rows
    In Using Smartsheet
    Hi, Is there a way to expand and collapse rows in the report builder just like the functionality that the sheets have? I want to be able to display in my project dashboard the same view that from the project sheet but unable to do so bec…
    226 4
    226 views 4 comments Most recent by Chris Atkinson Using Smartsheet
  • Generic timeline on Gantt chart
    In Using Smartsheet
    I'm trying to put together a Gantt chart with a generic timeline (i.e., Month 1, Month 2; Week 1, Week 2, etc.) rather than actual dates. Is there any way to do this in Smartsheet?
    Answered - Pending Review
    24 1
    Answered - Pending Review 24 views 1 comment Most recent by JeremiahHorstick Using Smartsheet