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?
Best Answer
-
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
Answers
-
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
-
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
-
Fantastic! Glad it worked.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!