Automating RYG balls
Presently I have a RYG IF formula to do the following.
=IF([Commitment Expiration Date]11 < TODAY(), "Red", IF([Commitment Expiration Date]11 = TODAY(), "Yellow", IF([Commitment Expiration Date]11 > TODAY(), "Green")))
I would like to change the automated RYG balls in my sheet to turn “Green” if the Due Date is in the future, “Yellow” if the Due Date is 3 months from today, and “Red” if the Due Date is in the past. How do I create this in Smartsheet?
Thank you for any advise and help!
Comments
-
Are you wanting the two to work in tandem? Or to replace the one you already have?
-
Mike,
Sorry for the serious delay in responding. I am looking to replace the existing formula with one that will flag or indicate the yellow on the RYG ball when an expiring account 3 months prior to the end date.
Thank you!
Jennifer
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!