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.
Status auto change
Hello,
I was wondering is it possible to make the status RYG color changes when it is closer to the due date?
For example: it shows red when it is due two days before the date and so on...
Is there a formula to right and what is the formula?
Thanks a lot
Comments
-
This is what I use to look 7 days ahead with a simple RYG indicator.
=IF(TODAY() - Finish# > 0, "Red", IF(TODAY() - Finish# > -7, "Yellow", "Green"))
-
Thank you very much for your help, now I am taking it to the next step, I am trying to make the colors go away if the checkbox is checked, I have done each color in a column and now I am stuck.
-
Hello,
We have a blog post on how to accomplish this, which can be found here (https://www.smartsheet.com/blog/support-tip-automate-RYG-balls).
I've also noticed that you've asked this question as it's own post, and I've answered the question more in depth there. This can be found here (https://community.smartsheet.com/discussion/checkbox-checked-cancel-ryg#comment-52041).
