Past Due Dates

Eric Tinney

I am having some difficulty in adding a formula so I can track how many days past due a task is. I've searched other disccussions and I have not been succesful.

 

I am using the "Project Sheet" templete and I have it filled out with actual dates and durations and Predecessors.  I have set up two Conditional Formating settings. One that would color the row RED if it is past the "Finish" date, Another to color white if it is 100 "% Complete". This is fine but the problem that I have is tracking past due tasks. 

 

I have a task Due 9/12/16. There are upwards of 50 other tasks that cannot be started until this one task is completed. So my probelm is when the task is completed I have to go in and manually change the "Finish" date for this task so that all of the other dependicies will change and I will see the actual proecty completion date. But it doesn't keep the origanal project completion date. If I add a third date column as "Completed" I then have to link all of my predessors to that column and not my "Finish" column.

 

I need to be able to track and report what tasks are past due and when they are actually completed. If I have to go change the origanal task "Finish" date, when I do a review at the end of the project no one will know what tasks got completed ontime or late.  I know in other systems there are ways to track this. I just don't know how to do it in Smartsheet. 

 

Any help or ideas are appriciated. 

Heidi Decker

Hi Eric,

Smartsheet does not have this functionality yet. It is on the long term change list. Here are some ideas that may help you with this.

https://community.smartsheet.com/discussion/baseline-functionality

I hope you find something that works for you.

Peace!