-
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").…
-
Linking Construction Program line items to relevant task lists
I'm working for a design and construct fit out company and we're looking to invest in control center and I'm just looking at the configuration of the project workspaces and need some ideas for the following scenario.... Each project has a construction programme which is shared with the client. Within that program there are…
-
Wacky Start Date When Using FF in Predecessors
Hi there, Working to update a plan today and I noticed that the use of the FF Predecessor Type will cause some weirdness with the start date. I've put an example in the graphic above but the summary is this: If you have two tasks that have the same duration and you want their completion dates to line up, the start date for…
-
Everybody should be able to see a Gantt view in Todays Date
Hi, As a Project department with many sub-departments, not everybody should be admins in the sheets or workspaces for that matter, but the "open view in Todays Date" is a functionallity that everybody, no matter permisson level, benefits of. So is it possible to make an enhancement where no matter permission level you are…
