Help: #INCORRECT ARGUMENT SET

Shirley Vue

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

Andrée Starå

Hi Shirley,

Try something like this.

=IF(OR(ISBLANK([1st PRODUCT_OWNER APPROVAL]@row); ISBLANK([2nd PRODUCT OWNER APPROVAL]@row)); ""; IF(AND([1st PRODUCT_OWNER APPROVAL]@row = "APPROVED"; [2nd PRODUCT OWNER APPROVAL]@row = "APPROVED"); "APPROVED"; IF(AND([1st PRODUCT_OWNER APPROVAL]@row = "DECLINED"; [2nd PRODUCT OWNER APPROVAL]@row = "DECLINED"); "DECLINED"; "NEEDS MODIFICATION")))

The same version but with the below changes for your and others convenience.

=IF(OR(ISBLANK([1st PRODUCT_OWNER APPROVAL]@row), ISBLANK([2nd PRODUCT OWNER APPROVAL]@row)), "", IF(AND([1st PRODUCT_OWNER APPROVAL]@row = "APPROVED", [2nd PRODUCT OWNER APPROVAL]@row = "APPROVED"), "APPROVED", IF(AND([1st PRODUCT_OWNER APPROVAL]@row = "DECLINED", [2nd PRODUCT OWNER APPROVAL]@row = "DECLINED"), "DECLINED", "NEEDS MODIFICATION")))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma."

Did it work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Excellent!

Happy to help!

✅Remember! Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi Shirley,

Try something like this.

=IF(OR(ISBLANK([1st PRODUCT_OWNER APPROVAL]@row); ISBLANK([2nd PRODUCT OWNER APPROVAL]@row)); ""; IF(AND([1st PRODUCT_OWNER APPROVAL]@row = "APPROVED"; [2nd PRODUCT OWNER APPROVAL]@row = "APPROVED"); "APPROVED"; IF(AND([1st PRODUCT_OWNER APPROVAL]@row = "DECLINED"; [2nd PRODUCT OWNER APPROVAL]@row = "DECLINED"); "DECLINED"; "NEEDS MODIFICATION")))

The same version but with the below changes for your and others convenience.

=IF(OR(ISBLANK([1st PRODUCT_OWNER APPROVAL]@row), ISBLANK([2nd PRODUCT OWNER APPROVAL]@row)), "", IF(AND([1st PRODUCT_OWNER APPROVAL]@row = "APPROVED", [2nd PRODUCT OWNER APPROVAL]@row = "APPROVED"), "APPROVED", IF(AND([1st PRODUCT_OWNER APPROVAL]@row = "DECLINED", [2nd PRODUCT OWNER APPROVAL]@row = "DECLINED"), "DECLINED", "NEEDS MODIFICATION")))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma."

Did it work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Shirley Vue

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

Andrée Starå

Excellent!

Happy to help!

✅Remember! Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!