Gantt Charts

 

Discussion List

  • Disregarding N/A in Formula
    In Formulas and Functions
    Hi, I've been using this formula: =IF(SUM(VALUE(RIGHT([Overall Summary Cost]@row, 1)), VALUE(RIGHT([Overall Summary Schedule]@row, 1)), VALUE(RIGHT([Overall Summary Risk]@row, 1))) < 5, "Blue", IF(SUM(VALUE(RIGHT([Overall Sum…
    Answered - Pending Review
    26 6
    Answered - Pending Review 26 views 6 comments Most recent by Paul Newcome 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…
    301 3
    301 views 3 comments Most recent by Tom L Formulas and Functions
  • Change Milestone Diamond Color
    In Using Smartsheet
    Hi everyone, I realized this question was asked in 2020. Are there any updates on having milestone diamonds in a different color? Appreciate any suggestions! 😀 
    Answered - Pending Review
    37 1
    Answered - Pending Review 37 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Calculated parent % complete issue
    In Formulas and Functions
    Hello - We are using one of the templates to track a project. We track % complete at the lowest level and then use the parent rolled up % complete. We are seeing a very strange error in the parent % complete. I have attached a few examples…
    Accepted
    54 4
    Answered ✓ 54 views 4 comments Most recent by JAM_BFT Formulas and Functions
  • Iterative Functionality (circular reference) in smartsheet.
    In Using Smartsheet
    I'm currently trying to find a way to do a simple iterative count using the automation tools in smartsheet. Simple iteration is one of the most basic tools in computer based problem solving, so it seems like a good feature to have built i…
    Answered - Pending Review
    59 2
    Answered - Pending Review 59 views 2 comments Most recent by Genevieve P. Using Smartsheet
  • Gantt Chart with multiple dates in one line?
    In Using Smartsheet
    Hello SmartSheet community! I'd like to double check with you if Smartsheets gantt charts has the posibility of displaying multiple dates in one row, I know there's been several posts regarding this topic, but I was hoping maybe the tool …
    3378 7
    3.4K views 7 comments Most recent by Andrée Starå Using Smartsheet
  • How to set the start date on a given day of week after predecessor completes
    In Formulas and Functions
    If I have a task that can only happen on a Tuesday (e.g. that's when an approval committee meets), and all the predecessors are scheduled to complete the previous Thursday, how do I schedule the task to start on the first Tuesday after th…
    Answered - Pending Review
    37 1
    Answered - Pending Review 37 views 1 comment Most recent by Genevieve P. Formulas and Functions
  • Sheet Summary Report with Dropdown
    In Using Smartsheet
    I'm creating a sheet summary report to use for a dashboard and have my source data broken out by phases. I'd like to be able to group the report data by phase, so I tried adding a single selection dropdown to the sheet summary. However, it…
    Answered - Pending Review
    29 1
    Answered - Pending Review 29 views 1 comment Most recent by Paul Newcome Using Smartsheet
  • Trouble with Project Management & Smartsheet Restrictions
    In Using Smartsheet
    I am trying to create a Smartsheet to track project completion (Integration) for my company and am running into multiple hurdles with the reporting. I'd love to hear your insight on how to overcome these issues without having to turn off a…
    Answered - Pending Review
    37 3
    Answered - Pending Review 37 views 3 comments Most recent by Genevieve P. Using Smartsheet
  • Column Highlight
    In Using Smartsheet
    is there the ability to colour in a column not a row to show for example UK bank holidays or staff holidays etc.. to show in a very quick visual way any clashes that might be avoided.  
    405 6
    405 views 6 comments Most recent by J.Po Using Smartsheet