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 calculate number of days overdue on a task
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
Comments
-
This thread might help:
https://community.smartsheet.com/discussion/automating-ryg-balls
The concept is the same.
Craig
-
Hi Craig,
This is very helpful.
Thank you for responding to my question.
Have a wonderful day!
Susanna
-
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
