Status is <> Complete and the Need by date is behind todays date then should change symbol to RED
IF the status is not COMPLETE and the need by date is behind todays date would want to have the color be Red. If it is current or in the future of todays date would be Green.
Been striking out... here was my latest try
=IF(Status@row <> "Complete", "Red", "Green"), IF(AND([Need by Date]@row<=TODAY()), "Red", "Green")))
Best Answer
-
Try this:
=IF(AND([Need by Date]@row <= TODAY(), (Status@row <> "Complete")), "Red", "Green")
Answers
-
Try this:
=IF(AND([Need by Date]@row <= TODAY(), (Status@row <> "Complete")), "Red", "Green")
-
Thank you this worked amazing!!!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.1K Get Help
- 443 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 129 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 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!