Help: #INCORRECT ARGUMENT SET

Trying to figure why this isn't working...the first two formulas seems to work but adding the third gives me the #INCORRECT error...Please let me know what I did wrong? =IF(ISBLANK([1st PRODUCT_OWNER APPROVAL]@row), "", IF(ISBLANK([2nd PRODUCT OWNER APPROVAL]@row), "", IF(AND([1st PRODUCT_OWNER APPROVAL]@row = "APPROVED", [2nd PRODUCT OWNER APPROVAL]@row = "APPROVED"), "APPROVED", "NEEDS MODIFICATION"), IF(AND([1st PRODUCT_OWNER APPROVAL]@row = "DECLINED", [2nd PRODUCT OWNER APPROVAL]@row = "DECLINED"), "DECLINED", "NEEDS MODIFICATION")))

Best Answers

Answers

  • Yes! It worked! (The commas formula) Thank you!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!