#INCORRECT ARGUMENT SET in Nested IF statement


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

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!