Getting Error on Formula - #INCORRECT ARGUMENT SET

Kari Hubmer

I am getting an error on the formula I have entered saying #INCORRECT ARGUMENT SET

=IF(AND([EHS COVID Approved]@row = "Yes", [ExComm Travel Approved?]@row = "Yes", "jeff.shepherd@advance-auto.com"))

Basically it is not inputting the Jeff.Shepherd@advance-auto.com email as the answer if the 2 conditions are met... not sure what I am doing wrong.... I used the following as just an "IF" statement and worked in another cell, but when I did the "IF/AND" together it is not working to put an email in...

=IF([EHS COVID Approved]@row = "Yes", "Jason.Reichert@advance-auto.com") - This one worked.

Paul Newcome

It is just a misplaced parenthesis. The AND function needs to be closed off before proceeding to the "output if true" portion of the IF function.

=IF(AND([EHS COVID Approved]@row = "Yes", [ExComm Travel Approved?]@row = "Yes"), "jeff.shepherd@advance-auto.com")

Kari Hubmer

It is basically showing me to pick a "Select a Contact" with the error... but then if I do, the formula disappears and the contact name then stays... trying to have it auto populate with the name/email if the 2 conditions are met

Paul Newcome

It is just a misplaced parenthesis. The AND function needs to be closed off before proceeding to the "output if true" portion of the IF function.

=IF(AND([EHS COVID Approved]@row = "Yes", [ExComm Travel Approved?]@row = "Yes"), "jeff.shepherd@advance-auto.com")

Kari Hubmer

Awesome, thank you, it worked ...

Paul Newcome

Happy to help. 👍️