#INCORRECT ARGUMENT SET in Nested IF statement

Drew Heath

Hey All,

I think I have all my ducks in a row here, but I continue to get a #INCORRECT ARGUMENT SET Error. Trying to dynamically set a status indicator. Can someone assist?

For more info:

[Assigned To] is a Contact List

[Resolved] is a checkbox

=IF(AND(NOT(ISBLANK([Assigned To]@row)), Resolved@row = 0), "In Progress", (IF(AND(NOT(ISBLANK([Assigned To]@row))), Resolved@row = 1)), "Completed", "Open")

Paul Newcome

Just need some adjustments to your parenthesis.

=IF(AND(NOT(ISBLANK([Assigned To]@row)), Resolved@row = 0), "In Progress", IF(AND(NOT(ISBLANK([Assigned To]@row)), Resolved@row = 1), "Completed", "Open"))

You could also shorten this a touch like so:

=IF([Assigned To]@row <> "", IF(Resolved@row = 1, "Completed", "In Progress"), "Open")

Paul Newcome

Just need some adjustments to your parenthesis.

=IF(AND(NOT(ISBLANK([Assigned To]@row)), Resolved@row = 0), "In Progress", IF(AND(NOT(ISBLANK([Assigned To]@row)), Resolved@row = 1), "Completed", "Open"))

You could also shorten this a touch like so:

=IF([Assigned To]@row <> "", IF(Resolved@row = 1, "Completed", "In Progress"), "Open")

Drew Heath

@Paul Newcome You rock! That was perfect!

Paul Newcome

Happy to help! 👍️