IF statement
lomorse
✭✭
I am working on a sheet and want to incorporate an IF (or maybe an IF AND) statement based on the date items are submitted to them for review, which is one of the date columns in the sheet.
Here are the conditions I want to test:
1) If today is less than or equal to 3 weeks from the submission date, turn the RYG ball Green.
2) If today is less than or equal to 6 but more than 3 weeks from the submission date, turn the RYG ball YELLOW.
3) If today is less than or equal to 8 but more than 6 weeks from the submission date, turn the RYG ball RED.
OR
Could this be better accomplished with Conditional Formatting?
Any help is appreciated!!
Comments
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 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!