Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
Hi,
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.
Thanks
% 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
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?
