Gantt Chart status bar doesn't appear to reflect progress

Our PM's are experiencing a few issues with the Gantt Chart, and I hoping someone can help.

In some instances, per the attached, the overall status suggests that the program is ahead of schedule. This is despite Sub-child 2a being on target. Any thoughts why this would occur?

We also utilise a formula that suggests how may days we are in-front or behind schedule.

=IF(AND([Start Date]@row <= TODAY(), [% Complete]@row < 1), ((Duration@row * [% Complete]@row) - (NETWORKDAYS([Start Date]@row, TODAY()))), "")

Generally, this formula works well if the program isn't complex, but as soon as we add multiple Parent/Child/Child tasks it doesn't seem to work. I've added an additional program which suggests we are 14 days behind program (progress bar and above formula) but from my take the project is on time.

Any experts have any ideas?

Find more posts tagged with

Construction

Gantt View

Project Management

Comments

Alejandra

Hi Richard,

It's possible this is related to the way that the % Complete is calculated in Parent Rows. In parent (summary) rows, the % Complete is calculated automatically by Smartsheet based on both the Duration and % Complete values you've manually entered into the child rows.

If needed, more information on this can be found in our help article: https://help.smartsheet.com/articles/765737-project-sheet-columns-start-date-end-date-duration-complete-and-predecessors#Complete

Nick Casiday

Richard,

Have you gotten any additional guidance on this? My organization is moving from MS Project to Smartsheet, but this problem is holding us up.

From what I've been able to determine, MS Project's % Complete Indicator on the Gantt Chart shows Actual % Complete as compared to Planned % Complete. Smartsheet seems to be wholly duration based, so the number of days that you claim value for in % Complete is divided by the added durations of all child tasks. That is the % Complete value in the parent row. The % Complete Indicator multiplies the % Complete in the parent row by the netdays of the project (including holidays and weekends regardless of the settings you use) and then shows that number of days as complete on the Gantt. This is unhelpful in showing if a project or program is on schedule.

Sign in to join the conversation!

Quick Links

Trending discussions

Automation - Move a row to a Sheet using where the Sheet Name is a row Column formula.
In the setup of an Automation to move a sheet row to a sheet name that actually a row cell value. Want the automation to allow the 'Move to:' value to come from a cell located on the row being moved. This would allow this sheet-to-sheet automation to happen without a manual entry and enhance the automation abilities ten…
What happened to Default View?
Hello, I'm no longer seeing the default view option in my sheets. For example, we have a shared PMO Calendar that was previously set to "Calendar View." When I accessed it recently, I noticed that the default filter option is no longer available. Has this functionality been removed? We recently moved to Enterprise, but I'm…
PTO/Absence tracker - how to deal with recurring events
I am creating a PTO/Absence tracker for our service technicians team. I have 2 separate input forms. - one to record/request PTO filled out by the service technicians themselves - another for Supervisors to book a service technician to a client site for a dedicated amount of time, - i.e., every MON for the next 3 weeks -…