formula help: Incorrect Argument Set

Options

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!