Formula Help

Lee Wood
✭✭✭
Good morning Community,
Please could somebody help me figure this out. When the schedule date = today, the status is turning red, whereas it should be yellow. Any date past today should be red only. I hope that makes sense!
=IF([Scheduled Date]3 = "", "", IF([Date Completed]3 <> "", "Green", IF([Scheduled Date]3 <= TODAY(), "Red", IF([Scheduled Date]3 <= TODAY(10), "Yellow", IF([Scheduled Date]3 >= TODAY(10), "Blue")))))
Thank you.
Tags:
Answers
-
Hi @Lee Wood ,
Change:
IF([Scheduled Date]3 <= TODAY(), "Red"
To:
IF([Scheduled Date]3 < TODAY(), "Red"
At the moment it is also including equal to, whereas you don't want it to.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 430 Global Discussions
- 150 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 500 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 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!