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"))

Find more posts tagged with

Accepted answers

Paul Newcome

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")

All comments

Paul Newcome

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.

Jeffrey Smith

Thank you Paul.

Paul Newcome

Happy to help! 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.