-
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!
-
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…
-
Be able to change finish date with automatic adjustment of duration or start dates
Once a project is scheduled using predecessors, Smartsheet automatically deleted the predecessors if someone manually changes a start (or finish?) date. Since we are trying to have team members be responsible for updating their tasks, it would be ideal if they could adjust their finish dates directly without the…