I keep getting #UNPARSEABLE when I use this formula. What am I doing wrong?
Here's the formula: COUNTIFS(Successors:Successors, HAS(@cell, Rownum@row), [% Complete]:[% Complete], OR(ISBLANK(@cell), @cell < 1)) = 0
Answers
-
Hello @Liz Christensen
Your function looks like you are trying to count specific values, but then check to see if they're equal to 0.
Is there more to the function? This looks like it could be a conditional statement that is part of another function.
If you remove the "=0" at the end, the function will count the values.
With the =0, I believe the return value will be either True or False. In this case, the column property needs to be a boolean like a checkbox.
-
What are you attempting to accomplish with this formula? It makes sense until you get to the = 0 at the end, that part has me confused.
-
I agree. Knowing the end goal of the formula would be very helpful in troubleshooting.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!