-
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…
-
#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!
-
Gannt chart help please
Hi, i'm using the excel template which smartsheet provide here: https://www.smartsheet.com/top-excel-project-plan-templates in the file ive downloaded the gannt chart looks lovely, however when i add in my project plan which has loads more tasks than the example, and over a greater time period the gannt chart severs no…
-
Can I copy gantt lines from one sheet to another and retain structure?
I have not been successful in copying a project plan (gantt) rows from one sheet to another and retain all hierarchies, durations, progress, dependencies, etc. to make a seamless copy/paste without having to rebuild.
-
Formula to calculate day from a series of dates and times
Hi All, This might be a long shot but is there a formula to search and find a multiple entries of a job number then look for the date column and calculate the series of dates for start and finish time and also include the in and out times to create a Gantt chart? This is all data that will be entered into a separate…