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
Check out the Formula Handbook template!