Formula to change Green Status to Red Status when date has expired
cking
✭
Hello,
I am looking for a formula that will automatically change Green Status to Red Status when the date has expired?
Thank you!
Tags:
Comments
-
Hello,
You can use the below formula.
=IF([Expiration Date]@row < TODAY(), "Red", "Green")
Best Regards,
Nikhil Chawla
-
Just make sure that the status RYG column is locked. Any manual changes of the status column to any color will overwrite the formula. I highly recommend automating every color-way or none at all. The other drawback is if you want people to manually adjust a column in a report, formulas make those cells uneditable in the reports.
I just wanted you to be sure of the consequences!
-
Thank you Mike!
-
Thank you!
-
You're welcome!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!