I keep getting #UNPARSEABLE when I use this formula. What am I doing wrong?

Liz Christensen

Here's the formula: COUNTIFS(Successors:Successors, HAS(@cell, Rownum@row), [% Complete]:[% Complete], OR(ISBLANK(@cell), @cell < 1)) = 0

MichaelTCA

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.

Carson Penticuff

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.

Paul Newcome

I agree. Knowing the end goal of the formula would be very helpful in troubleshooting.