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

Find more posts tagged with

Formulas

functionality

Accepted answers

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

All comments

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! 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.