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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!