IF statement
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
-
If you are trying to look at whether today is x number of weeks AFTER the submission date, you would use something like this...
=IF(TODAY() <= [Submission Date]@row + 21, "Green", IF(TODAY() <= [Submission Date]@row + 42, "Yellow", IF(TODAY() <= [Submission Date]@row + 56, "Red")))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!