formula help: Incorrect Argument Set

Jeffrey Smith

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

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

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

Jeffrey Smith

Thank you Paul.

Paul Newcome

Happy to help! 👍️