or Explore Discussions

# 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…
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! 😀
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…
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…
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…
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…