formula help: Incorrect Argument Set
Hello,
Please assist a novice. The Excel formula works as intended, but the Smartsheet formula throws an #Incorrect Argument Set error. What am I missing?
Thanks,
Jeff
Excel:
=IF(ISBLANK(B5),IF(A5>TODAY()+14,"greater than 14 days", IF(AND(A5<=TODAY()+14,A5>=TODAY()),"within 14 days", IF(A5<TODAY(),"overdue","error"))),"not blank")
Col A= Action Due (Date)
Col B = Action Completed (Date)
Smartsheet:
=IF(ISBLANK([Action Completed (Date)]16, IF([Action Due (Date)]16 > TODAY(14), "greater than 14 days", IF(AND([Action Due (Date)]16 <= TODAY(14), [Action Due (Date)]16 >= TODAY()), "within 14 days", IF([Action Due (Date)]16 < TODAY(), "overdue", "error"))), "not blank"))
Best Answer
-
You forgot to close out your ISBLANK function at the beginning. That also placed an extra closing parenthesis at the very end (to automatically close everything out) that will need to be deleted.
=IF(ISBLANK([Action Completed (Date)]16), IF([Action Due (Date)]16 > TODAY(14), "greater than 14 days", IF(AND([Action Due (Date)]16 <= TODAY(14), [Action Due (Date)]16 >= TODAY()), "within 14 days", IF([Action Due (Date)]16 < TODAY(), "overdue", "error"))), "not blank")
Answers
-
You forgot to close out your ISBLANK function at the beginning. That also placed an extra closing parenthesis at the very end (to automatically close everything out) that will need to be deleted.
=IF(ISBLANK([Action Completed (Date)]16), IF([Action Due (Date)]16 > TODAY(14), "greater than 14 days", IF(AND([Action Due (Date)]16 <= TODAY(14), [Action Due (Date)]16 >= TODAY()), "within 14 days", IF([Action Due (Date)]16 < TODAY(), "overdue", "error"))), "not blank")
-
Thank you Paul.
-
Happy to help! 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!