IF AND IS BLANK formula

reyesnatasha

I am trying to make a formula for an approval flow. I am trying to distinguish between requests that require approval and those that only require being informed. I am currently using the following formula, where the Reviewer 1 and Approver 1 are text columns containing names. I'm receiving the #INCORRECT ARGUMENT SET error code.

=IF(AND(ISBLANK([Reviewer 1]@row, ISBLANK([Approver 1]@row), "Inform", "Approve")))

Paul Newcome

You forgot to close out the AND function. Try moving on of the closing parenthesis from the very end to after the second ISBLANK function.

reyesnatasha

Thanks for the quick response! I adjusted and it worked. Thanks!

=IF(AND(ISBLANK([Reviewer 1]@row), ISBLANK([Approver 1]@row)), "Inform", "Approve")

Paul Newcome

You forgot to close out the AND function. Try moving on of the closing parenthesis from the very end to after the second ISBLANK function.

reyesnatasha

Thanks for the quick response! I adjusted and it worked. Thanks!

=IF(AND(ISBLANK([Reviewer 1]@row), ISBLANK([Approver 1]@row)), "Inform", "Approve")

Paul Newcome

Happy to help. 👍️