-
Hide non-working days in GANTT Views
I would be good to have an option to NOT display the non-working days when in GANTT view in a Sheet or Report. By displaying the weekends and holidays, This could be achieved by changing the Project Settings, in either Timeline Display or Dependency Settings (under edit Non-working days) as a checkbox. Without this option,…
-
Highlight conflicting predecessor relationships
It is possible to create predecessor relationships that are not possible. Consider: Task C is supposed to finish at the same time as Task A, but it can't because of other constraints. Currently, SmartSheet silently ignores a condition like this. This happens to me when trying to build a project around external constraints…
-
Pipedrive + Smartsheets
When a deal in my pipedrive reaches a new stage 'Job Scheduled' it automatically adds a new row to Smart Sheets with a Task Name and Duration. What I need Smartsheets to do next is automatically enter a starting and end date based off of the row above Predecessors and autofill a new Predecessors for the next row that will…
-
Is there a way to have data from one sheet auto update the start & finish date within a schedule?
I have built a schedule with proposed start/ finish dates (which are driving the Gantt) as well as a column for the actual start/ finish dates. I can link the actual columns to the data sheet where teammates are inputting their actuals, but those columns do not drive the Gantt chart to show if any lag has occurred. I am…
-
Representing Milestones landing in Financial quarters
Hi, I'm new to Smartsheet and hoping that what i'm trying to achieve may be possible but have drawn a blank on the help and community topics so far. I need to be able to represent that a project milestone is landing in a specific financial quarter and then have this represented on the Gannt chart. Ideally i would have…
-
Ability to “freeze” the Gantt Chart Bar
When a sheet is showing the Gantt Chart and you open the Sheet Summary, the left side of the Gantt Chart is pushed left to make room for the Sheet Summary. When you close the Sheet Summary the left side is not returned to where it was. EVERY TIME we access the Sheet Summary we need to drag the Gantt Chart back to where it…
-
How to change task bars of parent rows in the Gantt chart?
I set conditional formatting to change the task bars for each of my categories to the color that is represented in the Grid view. However, only the child rows are showing the bar color and not the parent rows. How do I get ALL the rows to show the color(s)? Thanks!
-
Gantt View Timeline color coded by stages
I am looking to develop a Gantt view that shows multiple colors on a single bar, based on the calendar, and corresponding stage of the project at that time. For example: Project XYZ, single timeline: red during planning stage (Oct 7-14), green during live stage (Oct 15-22), yellow during results review (Oct 23-29), etc I…
-
Use of Smartsheet for Preventive maintenance program
Hello, I looked at several tool to manage our maintenance program. We have several equipments with subcategory that I can organize with Parent and children relationship. I have a due date and a frequency of operation (industrial application: Replace hydraulic oil, replace wear plate etc). My plan: create 2018 maintenance…
-
Notify an assignee that the predecessor has complete his task.
I want to use smartsheet as an international project management tool. One thing is driving me creasy. I want to send out a notification to an assignee if the predecessor task is completed. Please find attached a screenshot of my scenario. The task in row 27 needs row 25 & 26 to be done ( active checkbox in column "done").…