If then greater than or equal to....
I am working on a task list that will return green, yellow, or red based on criteria with today's date and the due date. Everything appears to be working unless the total equals the today - the due date + 7. I have this column formula and one cell will not work correctly. Help!
=IF(TODAY() - [Due Date]@row < 0, "Green", IF(TODAY() - [Due Date]@row < Duration@row, "Yellow", IF(TODAY() - [Due Date]@row >= Duration@row + 7, "Red")))
I ended up changing the formula to =IF(TODAY() - [Due Date]@row < 0, "Green", IF(TODAY() - [Due Date]@row < Duration@row, "Yellow", IF(TODAY() > [Due Date]@row, "Red"))).
Answers
-
@blmccue When I put the formula in a test sheet it works for me. Did the formula end up working for you?
-
Shelby, the original formula would not work so I changed it to:
=IF(TODAY() - [Due Date]@row < 0, "Green", IF(TODAY() - [Due Date]@row < Duration@row, "Yellow", IF(TODAY() > [Due Date]@row, "Red"))).
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!