Change symbol based on date
Answers
-
Hello Everyone,
I've recently been put in charge with a project and I'm brand new to Smartsheets. I reaching out for some assistance with changing symbols by dates as followed. When today is before "Start Date", I want it to be yellow. When today is between Start Date and 5 days, I want it to be green. If today is 6 or more days after Start Date then I want it Red. I've used the formula above and modified it and it works except for Red only shows up on the 6th days after Start Date and reverts back green at 7 days and beyond. Here is the formula. =IF([Start Date]@row > TODAY(), "Yellow", IF([Start Date]@row <> TODAY(-5), "Green", "Red")) Please help me. Thank you.
-
@emaest01 Are you able to clarify what you are looking for?
-
When "Start Date" is future = Yellow
When Today is between "Start Date" and "Start Date" +5 days = Green
When Today is 6 days or more past "Start Date" = Red
Thank you.
-
Try this:
=IF([Start Date]@row> TODAY(), "Yellow", IF([Start Date]@row<= TODAY(-6), "Red", "Green"))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.9K Get Help
- 441 Global Discussions
- 153 Industry Talk
- 500 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 78 Community Job Board
- 511 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!