-
#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…
-
Include Gantt Chart in Dashboard PDF
Is there a way to include a gantt chart when printing a dashboard to pdf? I currently use the web widget to add the gantt chart to our dashboards, but when I try to print to PDF, the gantt chart is blank.
-
Working Days
Greetings, I have the start day and the duration. Is it possible to calculate the end date using these two entitites such that only working days are included (only monday through friday and not the weekends)? Thank you
-
Can you vary working days as part of duration?
I have some tasks that can only occur M-F in a schedule, and I have some other tasks that occur throughout a weekend. I don't know how to give the days different designations. I know there is a way on MS Project, but I have not figured it out for Smartsheet.
