Formula for status color
Hello, I am looking for the right formula to make the Status color change. My goal is to have the color change based on the days since updated. So the status will be green 0-179 days. Then Yellow when the days since updated is 180+ days, and turn Red if it's 360+ days.
Best Answer
-
=IF((TODAY() - [last updated]@row) < 180, "G", IF((TODAY() - [last updated]@row) < 360, "Y", IF((TODAY() - [last updated]@row) >= 360, "R")))
Answers
-
=IF((TODAY() - [last updated]@row) < 180, "G", IF((TODAY() - [last updated]@row) < 360, "Y", IF((TODAY() - [last updated]@row) >= 360, "R")))
-
Thank you so much for help James!
-
@James Keuning One problem is that is it not changing the status color. Any advice?
-
For formulas with Symbols, you'll want to specify the specific Symbol Name in "these" in your formula.
Ex. instead of "G", type "Green".
This Help Article shows the text needed for each symbol: Available Symbols in the Symbols Column
Cheers!
Genevieve
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!