Circular issue with countifs formula

Hi,

I have a circular issue with the formula below:

=COUNTIFS([Actual Go Live Date]:[Actual Go Live Date], [Actual Go Live Date]1, Hierarchy:Hierarchy, "2", [Guardian Client]:[Guardian Client], >0)

I tried this, same issue:

=COUNTIFS([Actual Go Live Date]:[Actual Go Live Date], [Actual Go Live Date]1, Hierarchy:Hierarchy, "2", [Guardian Client]:[Guardian Client], NOT(ISBLANK(@cell)))

I am trying to count the number of clients going live per month, for each row that is not blank.

Any idea what's going on?

Find more posts tagged with

Accepted answers

Anne-Solene Monrouzeau

Hi Heather,

The issue was that the formula was in one of the column called out in the formula. It works now! Thanks,

Anne-Solene

All comments

Heather Duff

Hi @Anne-Solene Monrouzeau ,

What column is this formula being placed in? If it's being placed in the Actual Go Live Date column, Hierarchy column, or the Guardian Client column, it won't work because these columns (in their entirety) are included in the formula. If it's in one of those columns, it gets confused because it's trying to "count itself."

Hope this helps!

Best,

Heather

Anne-Solene Monrouzeau

Hi Heather,

The issue was that the formula was in one of the column called out in the formula. It works now! Thanks,

Anne-Solene

Heather Duff

Fantastic! Glad it worked.

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.