Stumped with formula generated through AI helper

I recently created a formula using the AI tool, but it's returning #INCORRECT ARGUMENT SET and I can't figure out why.

The prompt that I entered was:

Count [Project] where [FY26] includes "Yes" or is blank, and where [Project Status] is not "Completed" or "Cancelled"

The formula that the tool returned was:

=COUNTIFS(Project:Project, <>"", OR(CONTAINS("Yes", [FY26]@row ), ISBLANK([FY26]@row )), [Project Status]:[Project Status], <>"Completed", [Project Status]:[Project Status], <>"Cancelled")

I'm not strong on complicated formulas so the AI tool has been a blessing, except in cases like this where it gives me a formula that returns an error!

Find more posts tagged with

Accepted answers

All comments

DKazatsky2

Hi @Scott Wadland ,

Give this a try. This assumes FY26 would have "Yes" as the only value, it "yes" is part of a larger string, you would need the CONTAINS piece.

=COUNTIFS([FY26]:[FY26], OR(@cell = "Yes", ISBLANK(@cell )), [Project Status]:[Project Status], AND(@cell <> "Completed", @cell <> "Cancelled"))

Hope this helps,

Dave

Scott Wadland

Hi Dave,

In the FY26 column, there are multiple strings that start with "Yes", so I guess I do need the CONTAINS piece. I tried replacing the @cell="Yes" with CONTAINS ("Yes",[FY26]@row) but now I'm getting an #UNPARSEABLE error. 😣

=COUNTIFS([FY26]:[FY26], OR(CONTAINS ("Yes", [FY26]@row ), ISBLANK(@cell )), [Project Status]:[Project Status], AND(@cell <> "Completed", @cell <> "Cancelled"))]

Thanks so much for your help!

DKazatsky2

@Scott Wadland

The CONTAINS section is a little off - here is what it should look like.

=COUNTIFS([FY26]:[FY26], OR(CONTAINS("Yes", @cell ), ISBLANK(@cell )), [Project Status]:[Project Status], AND(@cell <> "Completed", @cell <> "Cancelled"))

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.