-
Formula to Flag Tasks that are on the Critical and / or Driving Path
I'm aware how to highlight these in the Gantt, but if I wanted a checkbox to flag which tasks are on the CP and which ones are on the DP, anyone have an idea how to do that?
-
grantt view
i have created a report with data from 2 different sheets, each with "start"- data and "finish"-data, both columns are in the 2 sheets, the confiugration behind is for the the 2 sheets the same when i use a grantt view in the report, it displays in a correct way the data from the first sheet, but for the second sheet he…
-
How to exclude weekends while using formulas
I am very new to smartsheets and have just been playing with it and need guidance. I am trying to keep it as basic as possible. Essentially we are trying to backwards plan from our "due date" of when to begin our parts. i have it where you manually plug in a "shop time" and manually plug in a "outside lead time" have a…
-
7 AM shift start and Lunch time
Currently Smartsheet Project uses a default 8 AM time as the start date for each day in a project schedule. Is there a way to change that to 7 AM? I am stuck in creating a formula for that. Also, is there a way to take out the one hour lunch that is automatically calculated in a schedule?
-
Enable reports to show dependencies on the Gantt view
When creating a timeline report to be used on a Dashboard or exported for executive reporting, there is a need to preserve the dependency lines in the Gantt view to assist with understanding impacts of data changes. The Reports functionality does not currently show the dependency lines that are visible on the sheet. It…
-
How to preserve Gantt chart dependencies in a report?
Hello, I have created a report of my PP to display Gantt view of tasks and most importantly the dependencies on a dashboard report. However, the Gantt view loses all dependencies when you create a report!! Any solution to this? Thank you!
-
Toggle predecessor arrows on/off - clarity in the gantt view
With a lot of predecessors linking tasks, the gantt view can get crowded and hard to visualize with a lot of additional lines between tasks. I'd like the ability to toggle on/off the predecessor linking arrows. This was a setting in MS Project that I used quite frequently and miss in Smartsheet.
-
Enhance Predecessor Functionality to Maintain Connectivity and Adjust Dates for Forecasting
Enhance Smartsheet to automatically adjust predecessors without disconnecting when activity dates differ from baseline dates. Currently, predecessors disconnect when activity dates do not match baseline dates. We require a feature that keeps predecessors connected and adjusts dates to project or forecast new dates based on…
-
Dyanmic Approach Help
First explaining it slightly, the yellow columns show the sum of the specific cells within the week, currently i do it using range with =SUM(Qty5:Qty10) for the first week. However i wanna make it dynamic such that if i add more rows it wont be a mistake with the sum. For example if i bring up 3 rows from the second week…
-
Zeitachse
Welche gravierenden Vorteile hat die neue Darstellung "Zeitachse" gegenüber der bisherigen Gantt-Ansicht? Ist dies vorrangig eine andere Art der Visualisierung oder gibt es spezielle Funktionen, welche einzig über diese Darstellung ermöglicht werden? Welche Probleme löst diese neue Darstellungsmöglichkeit? Hat jemand…
