Impossible to countifs on an empty column

Hello,

i have this formula that works fine :

=IF(ISBLANK([Name of LE]@row), "", COUNTIFS({Fn}, "HR", {LEC - Action list conso pivot Range 1}, CONTAINS([Region / IE_ID]@row, @cell), {Stage}, "Stage0"))

However when I add this last condition :

=IF(ISBLANK([Name of LE]@row), "", COUNTIFS({Fn}, "HR", {LEC - Action list conso pivot Range 1}, CONTAINS([Region / IE_ID]@row, @cell), {Stage}, "Stage0"), {TgtDate}, "")

I get « INCORRECT ARGUMENT SET » error.

The TgtDate column is mostly empty so it should work I think. But it doesn’t.

thanks for your ideas to troubleshoot this !

best,

Pierre-Eric

Find more posts tagged with

Accepted answers

Pierre-Eric Collette

Thanks Carson... i must have been tired on this one.

Appreciate the fresh pair of eyes

Best,

Pierre-Eric

All comments

Carson Penticuff

Try tucking the last condition inside the COUNTIFS closing paren.

=IF(ISBLANK([Name of LE]@row), "", COUNTIFS({Fn}, "HR", {LEC - Action list conso pivot Range 1}, CONTAINS([Region / IE_ID]@row, @cell), {Stage}, "Stage0", {TgtDate}, ""))

Pierre-Eric Collette

Thanks Carson... i must have been tired on this one.

Appreciate the fresh pair of eyes

Best,

Pierre-Eric

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.