Countifs return 0 out of nowhere
Hello,
I have several sheets where I use Countifs using a referenced sheet and they were working fine until recently that now return 0. I tried remove a reference and then redo it and it still returned zero. My guess is that there is something going on with smartsheet itself. Here's an example of the countifs that used to work fine and won't:
=COUNTIFS({AC-2B_Completness}, Status@row, {BU_Completness}, BU@row, {Phase_Completness}, Phase@row)
Answers
-
Your formula looks fine, but that would make sense if it were previously working. Is it possible something changed in your source sheet? If it is populated by formulas or data shuttle, there is always the possibility of some datatype confusion… number/text, date/text. You can try splitting up the conditions to see if any single one is causing the issue:
=COUNTIFS({AC-2B_Completness}, Status@row)
=COUNTIFS({BU_Completness}, BU@row)
=COUNTIFS({Phase_Completness}, Phase@row)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!