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

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.

 

Hope this helps.

 

- David