Changing Color Symbols by Number of Days from Due Date
I'm trying to show the risk of a project running off of today's date compared to due date.
Here is the criteria:
If less than or equal to 3 days to due date from today color Red.
If greater than 3 days but less than 8 days to due date from today color Yellow.
If greater than or equal to 8 days to due date from today color Green.
Here's what I have but I keep getting an Unparseable error:
=IF([Pendo Due Date]@row <= Today (3), "Red", IF(AND([Pendo Due Date]@row > Today (3), [Pendo Due Date]@row < Today (8)), "Yellow", IF([Pendo Due Date]@row >= Today (8), "Green", ))
Best Answer
-
Dumb mistakes on my part. Thank you for looking at it.
Answers
-
Try this. There were a few issues with yours. First, TODAY() is a function and should be capitalized, with no space before the (0). There was a missing parentheses to close out your AND statement. And there was an extra comma at the end.
=IF([Pendo Due Date]@row <= TODAY(3), "Red", IF(AND([Pendo Due Date]@row > TODAY(3), [Pendo Due Date]@row < TODAY(8)), "Yellow", IF([Pendo Due Date]@row >= TODAY(8), "Green"))
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Dumb mistakes on my part. Thank you for looking at it.
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!