-
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…
-
#blocked Formula
I have a sheet that used to be operationnal, and sudenly, I get "#BLOCKED" on some of my formula. I know that the formula should be ok because I have the exact same formula in similar pages. In fact, the formula is a nice addition to the GANTT view. It list all the predecessor task by taskname. I have another one for all…
-
Gantt Bar with Milestone
Is there a way to include a milestone marker on the Gantt bar? In the example below, we would like to show the go-live date as a milestone along the Gantt bar of the execution phase.
-
Schedule Variance
How can I copy columns from one template and add them to a different template? I want to add the date variance column from the Project Gantt and budget template and add them to the Project plan template. I just want a way to baseline and track schedule variance.
-
How to count inventory used per day in Gantt chart
Hello, I have a Gantt chart that has inventory requests by location. I am trying to find a way to use the COUNTIFS function to count how much inventory is out on location on any given day. What is the best way to do this? I have been trying to use the Sheet Summary but not having much luck. Thank you!
