Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

How to analyse/illustrate slippage of tasks in Smartsheet

edited 12/09/19 in Archived 2017 Posts
11/16/17 Edited 12/09/19


I would like to get my sheets to highlight tasks which are overdue for completion in Smartsheet, and any subsequent tasks which may slip as a result. I imagine I will need to do a formula for this would be grateful for any advice on how to do this.




Popular Tags:


  • % Complete <> 1  and End is in the past

  • Hello, 

    The best way to keep track of critical tasks in your project is to use the Critical Path. A critical path is a technique used to complete projects on time by focusing on key tasks. Once you insert predecessor values in the sheet to show the dependency between tasks, you will be able to Click the Critical Path icon  in the Gantt chart header to highlight all the critical tasks of your project. 

    To highlight overdue tasks, you will want to set up conditional formatting for when the Due Date is in the past like in the screenshot below. 

    Your data will then look like the screenshot below. 

    Learn how to set up Conditional Formatting here: https://help.smartsheet.com/articles/516359-conditional-formatting

    Learn how to set up the Critical Path here: https://help.smartsheet.com/articles/1979152-tracking-a-project-s-critical-path

    Screen Shot 2017-11-16 at 4.09.31 PM.png

  • Thanks Pam, I've set up a rule as per your reply and it looks good. Taking this a bit further, is there any way I could make this rule also highlight subsequent tasks which would also be put at risk of slippage?

This discussion has been closed.