How to calculate number of days overdue on a task

Susanna Chan

Hi,

I am new to the community.

I would like to create a status field that changes color based on number of days overdue.

Is there a way to calculate the number of days overdue in smartsheet?

Thanks in advance!

Susanna

Find more posts tagged with

Project Management

Comments

J. Craig Williams

This thread might help:

https://community.smartsheet.com/discussion/automating-ryg-balls

The concept is the same.

Craig

Susanna Chan

Hi Craig,

This is very helpful.

Thank you for responding to my question.

Have a wonderful day!

Susanna

David Dunn

Hi Susanna,

The previous discussion cited referred to signalling lateness with the RYG balls. For a simple numerical calculation of lateness, see the following discussion.

https://community.smartsheet.com/discussion/calculating-lateness

Once I had the numerical deviation from the baseline dates, I used conditional formatting to highlight activities that were completed early, on time, late or very late.