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.
IF Statement to change cell color automaticlly using dates
Thanks Smart Sheet people for helping out with formulas. No doubt Craig & Andrew and others who have helped are way smarter than me. Its given me a spring board to learn from. Hope someone finds this helpful
The formula below is used in conjunction with a column (you need to set up) that will return"Yellow", "Blue", "Red" in this case, When you set up "Conditional Formatting" to return the cell or font or what every you choose. Hide the column, and change if you see fit.
=IF(AND((TODAY() - [Last Contact Date]21) > 90, (TODAY() - [Last Contact Date]21) < 180), "Yellow", IF(AND((TODAY() - [Last Contact Date]21) > 181, (TODAY() - [Last Contact Date]21) < 365), "Red", ""))
Comments
-
This one,
=IF(AND((TODAY() - [Last Contact Date]2) > 90, (TODAY() - [Last Contact Date]2) < 180), "Yellow", IF(AND((TODAY() - [Last Contact Date]2) > 181, (TODAY() - [Last Contact Date]2) < 365), "Red", IF((TODAY() - [Last Contact Date]2) > 365, "Blue")))
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives