Gantt Charts
Discussion List
-
Disregarding N/A in FormulaIn Formulas and FunctionsHi, 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 views 6 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Formula under Duration in a Gant chartIn Formulas and FunctionsHi 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…
-
Change Milestone Diamond ColorIn Using SmartsheetHi everyone, I realized this question was asked in 2020. Are there any updates on having milestone diamonds in a different color? Appreciate any suggestions! 😀
-
Calculated parent % complete issueIn Formulas and FunctionsHello - 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…
-
Iterative Functionality (circular reference) in smartsheet.In Using SmartsheetI'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…
-
Gantt Chart with multiple dates in one line?In Using SmartsheetHello 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 …
-
How to set the start date on a given day of week after predecessor completesIn Formulas and FunctionsIf 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 views 1 comment 0 points Most recent by Genevieve P. Formulas and Functions
-
Sheet Summary Report with DropdownIn Using SmartsheetI'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…
-
Trouble with Project Management & Smartsheet RestrictionsIn Using SmartsheetI 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…
-
Column HighlightIn Using Smartsheetis 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.