Nested IF - Incorrect Argument
Hoping someone may be able to spot my error. Attempting to return 1 of 5 statuses (Complete, Not Started, Late, Pending, or In Progress). I think the challenge is with the Pending status, where I am trying to flag a due date within 7 days of today.
=IF([Percentage Complete]1 = 1, "Complete", IF([Due Date]1 < TODAY(), "Late", IF([Start Date]1 > TODAY(), "Not Started", IF(AND([Due Date]1 > TODAY(), TODAY() > [Due Date]1 - 7, "Pending", "In Progress")))))
Thanks!
Comments
-
It's almost right - I used the formula:
=IF([Percentage Complete]1 = 1, "Complete", IF([Due Date]1 < TODAY(), "Late", IF([Start Date]1 > TODAY(), "Not Started", IF([Due Date]1 <= TODAY() + 7, "Pending", "In Progress"))))
See the screenshot - I hope this helps?
Sean
-
Excellent. Thanks, Sean.
-
To add on...
The problem with your original formula is that you did not close your AND statement.
=IF([Percentage Complete]1 = 1, "Complete", IF([Due Date]1 < TODAY(), "Late", IF([Start Date]1 > TODAY(), "Not Started",
IF(
AND([Due Date]1 > TODAY(), TODAY() > [Due Date]1 - 7),
"Pending", "In Progress"))))
.
Notice I added a closing parenthesis after the 7 and removed one from the end of the formula.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives